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

[PBI_V2]

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

[amitchandak · Accepted solution]

@PBI_V2 , 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])