Forum Discussion
COIL-ibesmond
Helper I
Helper IDAX 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. 😄
talespin
Solution Sage
Solution Sage
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. 😄
COIL-ibesmondHelper I
Helper IThanks 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.
- talespin
You're welcome. Duplicate measure are a clutter but measures do not add to size of report.