LastNonEmpty in Tabular mode: Part 2, Last Ever Non Empty in DAX
User Rating: / 1
Written by Javier Guillen   
Tuesday, 12 June 2012 20:58

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.



Tags: dax, tabular

XL Cubed