LastNonEmpty in Tabular mode: Part 2, Last Ever Non Empty in DAX

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

One of the most useful inventory calculations is what Chris Webb referred to as 'Last Ever Non Empty'. This calculation differs from the regular MDX Last Non Empty aggregation in that it will yield, for each dimension member at the granularity specified, the fact value on the last date for which there was data even if that date happened before the selected time frame.

Read more...

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.