ASSIGN two values for the same switch measure.

[Anonymous]

Hey guys, 
Can you assign two measures to the same switch? Like this is my switch measure: 

MeasureSWTICH BNK NEW NEWW = SWITCH(MAX('Table (2)'[Type]), "2020", [2020],[2019])

Table(2) Type has two rows: 2019 and 2020. 

Columns over here ade using MTD and MTD LY, so i cant simply put the year in the legend.

This is what I get right now : 

This is what I want basically: 

[manikumar34]

@Anonymous , 

Place MTD and MTD LY on values (two measures)

Regards, 

Manikumar

[V-pazhen-msft · Accepted solution]

@Anonymous 
Put Date on the x axis with the 2 measures MTD and MTD LY.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))

Use that with Year from date table

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.