Forum Discussion
Need help with SWITCH funtion
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;
1) Fact_Incident
2) Delivery
3) Customer Experience
These are the following data and columns in each table
Fact_Incident Table:
TAT Time --> (Column Name)
1
Delivery Table:
No of Enhance No. of sustain -->(Column Name)
3000 445
Custom Table: (This is out put table where Score is empty)
Name Score -->(Column Name)
USA
UK
Canada
After SWITCH or any CASE function i would like to see table as below;
Custom Table: (Fianl Output)
Name Score -->(Column Name)
Enhance 3000
Sustain 445
TAT 1
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.
Thanks