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.
Click here to read more about the November 2022 updates!
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.