Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX - Conditional Measure that should display value from 2 different measures

Hello All,

We need to create a measure that should dipslay values from 2 different measures based on Max (Year-Month) of DimDate. We have two measure
1) Current Compliance
2) Historical Compliance


Compliance = IF MAX(YearMonth) then "Current Compliance" else "Historical Compliance"

 

Thanks,
PBI V2

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , Hope you have Month Year in format YYYYMM

     

    Create a new measure

    If( Max(Table[Month Year]) = Maxx(allselected(Table), Table[Month Year]) , [Current Compliance],[Historical Compliance])

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , Hope you have Month Year in format YYYYMM

     

    Create a new measure

    If( Max(Table[Month Year]) = Maxx(allselected(Table), Table[Month Year]) , [Current Compliance],[Historical Compliance])