Forum Discussion
Converting static to Dynamic Measure
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] ) )
Good morning Anonymous
this is exactly what I was trying to do. Her is the explanation of my idea and let me know if anything does not seem right.
The latest verion corresponds to the latest date available in the MASTER table. I started with calculating the last date avialable in the master table by removing all filters.
using this date I calculated the corresponding version and again by removing all filters.
this should give me the last version which I can refer to in your measure. Not sure wht goes wrong? Please correct me if I missed something.
Hai tamerj1
Can you suggest some other way based on version
and
please guide this i am trying to solve through this
I am trying to create a calculated column based max of forecast version column based on max version flag. but this is showing wrong
version flag represnts number of each version