Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi all,
I have the following situation:
I would like to define number 0 to On Time, 2 to Delayed... but this SWITCH function doesnt support comparing values of type integer with values of type text...
Any suggestions?
Many thanks!
Solved! Go to Solution.
Don't put the number in between inverted commas.
i.e.
Column = SWITCH('Fact WaitingroomInsights'[Time],0,"On Time",2,"Delayed",-4,"Earlier than planned",8,"Other")
Note:
1) Only put text in between inverted commas.
2) If this doesn't work, make sure your the Time column's data type is Whole Number by going to Edit Queries.
Don't put the number in between inverted commas.
i.e.
Column = SWITCH('Fact WaitingroomInsights'[Time],0,"On Time",2,"Delayed",-4,"Earlier than planned",8,"Other")
Note:
1) Only put text in between inverted commas.
2) If this doesn't work, make sure your the Time column's data type is Whole Number by going to Edit Queries.
User | Count |
---|---|
84 | |
79 | |
69 | |
46 | |
43 |
User | Count |
---|---|
106 | |
50 | |
49 | |
40 | |
39 |