SWITCH function and time intelligence

Marjss — Mon, 04 Dec 2017 23:16:13 GMT

Hi!

I was hoping you guys could help me with this...

I'm building a KPI Dashboard, and I need to create a button (with the SWITCH function, i'm guessing), that changes the values between Current Month x YTD x Last Year on Budget and Actual on the charts.

I've tried inumerous ways of doing it, but my problem always seems to be that the selector won't work!

It just gives me the same number, wether I select YTD, Actual or Last Year.

I have also tried searching for this on this forum, but I can't seem to find anything!

The measures I'm using:

Actual = CALCULATE([SumAmount2];Scenario[ScenarioName]="Actual")
ActualQTD = CALCULATE([Actual]; DATESQTD(Calendar[Date]))
ActualYTD = CALCULATE([Actual]; DATESYTD(Calendar[Date]))

same for budget.

And the switch function:
Actual Select = SWITCH([SelectorNum]
; 1; [Actual]
; 2; [ActualQTD]
; 3; [ActualYTD]
)

This selector Num is a measure:

SelectorNum = MIN(SelectMeasure[SelectorNumber])

The Selector Number is a standart table to use for SWITCH functions, which includes:

Selector Selector Number
Current 1
QTD 2
YTD 3

Any help will be much aprreciated!! I have been struggling with this issue for a while now, and no one in my company knows anything about Power BI.

Thank you!

topic SWITCH function and time intelligence in DAX Commands and Tips

SWITCH function and time intelligence