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 » DAX   (RSS)
Showing page 2 of 11 (101 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
  • Distinct Count in DAX Query Plans #dax #tabular

    In the last months I and Alberto Ferrari worked on many consulting engagements about designing Tabular models or optimizing existing ones. One of the strength of the Tabular model compared to Multidimensional is the performance of distinct count measures. Now, being faster doesn’t necessarily mean getting an immediate answer, and several times we ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 21, 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
  • 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
  • Videos about #DAX on Project Botticelli

    More than one year ago, I and Alberto started recording videos for Project Botticelli, and now we have a set of videos about DAX that you can watch online. There are a few videos free, and others are available in the monthly subscription. If you are interested, use this 20% discount code before the end of the December 2013: SQLBI20HOLS2013 The ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 11, 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
  • Using USERELATIONSHIP function in Measures and Calculated Columns #dax #powerpivot #ssas

    You can use the USERELATIONSHIP function in DAX to apply a non-active relationship in a particular DAX calculation. This approach is usually simple in a measure (just use USERELATIOSHIP in one of the filter arguments of CALCULATE) but as soon as you try using it in a calculated column, you can find several issues. In the article USERELATIONSHIP ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 1, 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