LastNonEmpty in Tabular mode: Part 2, Last Ever Non Empty in DAX
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...