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. 😄
Thanks for the response. I though about making duplicate measures, but it would add too many new measure to the report, which is already over 1 GB.
You're welcome. Duplicate measure are a clutter but measures do not add to size of report.