Forum Discussion
Dax Error
Hai All , Can you help me to rectify this dax error.
I was trying to create a version flag based on attribute(date) and version flag column (Numerical column)
Thanks
Alan
Anonymous
Please try
Version Month Selection Flag = VAR SelectedTable = ALLSELECTED ( 'T1 Data Base' ) VAR Maxversion = MAXX ( SelectedTable, 'T1 Data Base'[Version Flag] ) VAR Mindate = MINX ( FILTER ( SelectedTable, 'T1 Data Base'[Version Flag] = Maxversion ), 'T1 Data Base'[Attribute] ) RETURN IF ( MAX ( 'T1 Data Base'[Attribute] ) >= Mindate, 1, 0 )
1 Reply
Anonymous
Please try
Version Month Selection Flag = VAR SelectedTable = ALLSELECTED ( 'T1 Data Base' ) VAR Maxversion = MAXX ( SelectedTable, 'T1 Data Base'[Version Flag] ) VAR Mindate = MINX ( FILTER ( SelectedTable, 'T1 Data Base'[Version Flag] = Maxversion ), 'T1 Data Base'[Attribute] ) RETURN IF ( MAX ( 'T1 Data Base'[Attribute] ) >= Mindate, 1, 0 )