Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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
Need Help
Show and Tell
  • tamerj1's avatar
    tamerj1
    4 years ago

    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 )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

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 )