Forum Discussion
Solved
DAX FORMAT function Alternative - Switch Statement
I'm trying to build a switch statement, but I'm running into a formatting problem. I'm using FORMAT(ActualVsBudgetPerc, "Percent" ) but this turns my value into a string which I want to avoid bec...
Under such scenario, I usually create two measures, one that only returns numeric data types and other one with format applied for display purpose just like an Elephant, one set for display teeth and another real set for chewing. 😄
Decided to go old-school and dropped the % from the value and multiplied it by 100.