-
Sorting a column by using another column is one of the nice features of the new version of PowerPivot introduced with SQL Server 2012 (we call it PowerPivot v2, but it really v11 because it is aligned with SQL Server).… Read more
-
UPDATE 2018-03-03: the Azure DataMarket is no longer supported by Microsoft, but if you need a Calendar table you can now use the DAX Date Template. Boyan Penev announced the availability of DateStream project on CodePlex: it is a data… Read more
-
If you think PowerPivot and Tabular are good tools but sometime the design tools are not fast/complete/flexible enough, please consider voting this suggestion on Connect to request a textual representation Tabular or PowerPivot Data Models. This is the simplest way… Read more
-
I recently read the blog post from James Serra Tabular model: Not ready for prime time? (read also the comments because there are discussions about a few points raised by James) and the following post from Christian Wade Multidimensional or… Read more