Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I have two tables below one from salesforce - opportunity and one from excel
I wanted to create a dynamic measure base on a slicer which will be from the excel table and multiply the value to the opportunity table
so for example, if the slicer is set to commodities at 2/5/2021 then I want the equation for 2021 assumption to multiply the filtered values :
Is it possible?
So far Ive gotten to
Thanks so much in advance
@powerbiwork First, use a SWITCH or SWITCH(TRUE()...) statement instead of IF statements. Second, seems like you would want to base that SWITCH statement on the value in your slicer, SelectedDivision
@Greg_Deckler thank you I will give that a try.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.