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 » Tabular » PowerPivot   (RSS)
Showing page 2 of 5 (41 total posts)
  • Common Statistical #DAX Patterns for #powerpivot and #tabular

    DAX includes several statistical functions, such as average, variance, and standard deviation. Other common algorithms require some DAX code and we published an article about common Statistical Patterns on www.daxpatterns.com, including: Average Moving Average Variance Standard Deviation Median Mode Percentile Quartile I ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 20, 2014
  • LASTDATE vs. MAX? CALCULATETABLE vs. FILTER? It depends! #dax #powerpivot #tabular

    A few days ago I published the article FILTER vs CALCULATETABLE: optimization using cardinality estimation, where I try to explain why the sentence “CALCULATETABLE is better than FILTER” is not always true. In reality, CALCULATETABLE internally might use FILTER for every logical expression you use as a filter argument. What really matters is the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 6, 2014
  • Implement Parameters using Slicers in #powerpivot #dax #tabular

    Apparently you cannot pass an argument to a DAX measure. In reality, you can interact with a slicer that has the only purpose of representing a parameter used by a DAX formula. You just create a table in the Power Pivot or Tabular data model, without creating any relationship with other tables in the same data model. This techniques is similar to ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 27, 2014
  • Distinct Count calculation on dimension attribute in #dax #powerpivot #tabular

    Creating Distinct Count calculations in DAX is pretty easy when the target of the operation is a column in the “fact table” of a star schema. When you want to apply the DISTINCTCOUNT function to a dimension attribute (such as Customer Country, Product Model, Employee Department, and so on), you need to apply one of the techniques described in ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 21, 2014
  • 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
  • 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
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement