Tune your PowerPivot DAX query, don’t use the entire table in a FILTER and replace SUMX if possible

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

I was working on a PoC that needed a measure where I had to use some more advanced DAX functions. In this case I had two fact tables and the customer wanted to have the sales of a specific store, but only if they had a booking in the same period.

To cut straight to the DAX, this formula does the trick:

Read more...

 

Tags: performance, dax, excel

 

2007-2015 VidasSoft Systems Inc.