Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Marjss
Frequent Visitor

SWITCH function and time intelligence

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!

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.