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?
- damit231836 years ago
Microsoft Employee
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