THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » PowerPivot   (RSS)
Showing page 2 of 14 (138 total posts)
  • The Cumulative Total #dax pattern

    The first pattern published on www.daxpatterns.com is the Cumulative Total. Another common name of this calculation is Running Total, but the reason why we named the pattern in this way is that we identify all those scenarios in which you want to obtain a value, at a certain date, that corresponds to the result of a number of transactions executed ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 20, 2014
  • DAX Patterns website official launch! #dax #powerpivot #tabular

    I’m very proud to announce the official launch of the DAX Patterns website! http://www.daxpatterns.com I and Alberto Ferrari worked on this idea for a really long time. Many business scenarios can be solved in Power Pivot using always the same models, with just a few minor changes. This is especially true for the DAX formulas required. Sometime, ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 18, 2014
  • Scheduled Data Refresh in Power BI #powerbi #powerpivot

    Now that Power BI is finally available (I still use terms as “released” for software and “in production” for a service…) I made some test on the new Scheduled Refresh option that you have for your models (other info here. First of all, the Refresh feature within the Excel workbook no longer works, at least when you are using Data Management ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 11, 2014
  • Natural and Unnatural Hierarchies in #powerpivot and #tabular

    Last week I wrote an article about Natural Hierarchies in Power Pivot and Tabular where I show why it is important creating natural hierarchies for performance reasons. I’d like to spend a few words about the reasons why this is so important, so you might read the article in advance before moving forward. I had to investigate on a performance ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 4, 2014
  • Using Added Columns in #DAX Queries

    I had an issue in a query that reminded me a few details naming columns created by ADDCOLUMNS. When you specify a simple name in ADDCOLUMNS, you can use it later, for example in a SUMMARIZE or in a FILTER expression, such as in the following example (see the Value column): EVALUATE CALCULATETABLE (     ADDCOLUMNS ( ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 21, 2014
  • Training for DAX, Tabular and Power Pivot in 2014 #powerpivot #dax

    I hadn’t time in the last two months for new blog posts, but with some good reasons! I’ve been busy putting DAX Formatter online and writing some other stuffs that I will be happy to share very soon, aside from daily engagements with customers, of course. But the waiting is almost over, and in the meantime I’d like to share the schedule for ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 15, 2014
  • Power Query now imports relationships #powerquery #powerpivot

    The December release of Power Query preview (version 2.9.3502.261) introduced an interesting feature: when you import multiple tables in the data model, relationships existing between tables in the data source are automatically detected and added to the data model as well. This is similar to the behavior you have in Power Pivot, but there is an ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 17, 2013
  • Format your #dax code with DAX Formatter

    When you write a DAX formula that is not trivial, you end up having a complex expression that is not really readable. I think that the same problem affect in part all Excel users, but in Excel you can easily split a formula in many steps, using different cells. This is not always possible in Tabular, because moving a sub-expression in a separate ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 13, 2013
  • Difference between LASTDATE and MAX for semi-additive measures in #DAX

    I recently wrote an article on SQLBI about the semi-additive measures in DAX. I included the formulas common calculations and there is an interesting point that worth a longer digression: the difference between LASTDATE and MAX (which is similar to FIRSTDATE and MIN – I just describe the former, for the latter just replace the correspondent ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 22, 2013
  • Handling Wrong or Missing Dates in Tabular and #powerpivot #dax

    Recently I received a request from a reader related to the handling of missing or invalid dates in Tabular (but the same can be applied to Power Pivot). In the Analysis Services Tabular book, we wrote that you can insert a special row in the Date table with an ID that can be used to map all the rows in the fact table that don’t have a valid date. ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 24, 2013
< Previous 1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement