Forum Discussion
Solved
Setting different data types for measures used in SWITCH function
Hi, I have two values in my SWITCH function as below: SWITCH ( SELECTEDVALUE('ColumnA') ,1, CURRENCY('Sales') -- and added $ in front of the displayed currency by using the $ s...
Hi Smile ,
There is not a way to do this with a SWITCH statement. Microsoft recommends trying calculation groups.
You can vote for the idea here:
https://ideas.powerbi.com/ideas/idea/?ideaid=09c2a6d2-d215-4d68-b500-21167d177461
Calculation groups:
https://www.sqlbi.com/articles/controlling-format-strings-in-calculation-groups/
Hi Smile ,
There is not a way to do this with a SWITCH statement. Microsoft recommends trying calculation groups.
You can vote for the idea here:
https://ideas.powerbi.com/ideas/idea/?ideaid=09c2a6d2-d215-4d68-b500-21167d177461
Calculation groups:
https://www.sqlbi.com/articles/controlling-format-strings-in-calculation-groups/