Forum Discussion
Converting static to Dynamic Measure
Hai All, I am expecting a super solution for this requirement. The requirement is Currently I am working on a sales dashboard and every year this report is having different versions of tables for ...
Hi Anonymous
Please try something likeMeasure1 = VAR LastDateWithData = CALCULATE ( MAX ( MASTER[Date] ), REMOVEFILTERS () ) VAR LastVerion = CALCULATE ( MAX ( MASTER[Version] ), MASTER[Date] = LastDateWithData, REMOVEFILTERS () ) RETURN CALCULATE ( SUM ( Sales[Values] ) / 1000, MASTER[Version] = LastVerion, ALL ( MASTER[Comparison] ) )
