I need some help in creating SWITCH funtion which is nothing but CASE statement in POWERBI.
SWITCH funtion has used to calculate final output based on conditions and values will be come from different tables.
USA, UK , Canada
Score1Measure: 4000 for USA
Score2Measure: 1 for UK
Score3Measure: 0 for CANADA
After applying Switch funtion like below;
it gave me wrong output as shown in table below. USA should have 3000. It does look like automatically average out but i checked data type and summary which is SUM. Not sure what could be wrong here. Any advise would be appreciated!
The switch across the table needs aggregated values from other tables. Can you share some better sample data and sample output?
There are total 3 Tables in data PowerBI data model;
3) Customer Experience
These are the following data and columns in each table
TAT Time --> (Column Name)
No of Enhance No. of sustain -->(Column Name)
Custom Table: (This is out put table where Score is empty)
Name Score -->(Column Name)
After SWITCH or any CASE function i would like to see table as below;
Custom Table: (Fianl Output)
Hope this will give you more detail.
NOTE: There is no relationship between source table and output table this is just case statement i would like to use here and put whatever value is there in source.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.