Forum Discussion
PBI only recognize % as Text type after using Dax: Format ( value, "0.0%) - Help
The FORMAT() syntax always converts the value to string. So if your aim is to make calculations it is not possible to use FORMAT().
To my knowledge you will not be able to mix percentage with number formatting while still maintaining numeric format on your column/measure.
Is it possible nowadays?
Hi vitorgps ,
To my knowledge this is still the case.
But you can always have a completly numeric measure in the backgroud that you use for calculations, while displaying the formatted one.
So if you have two formatted measures displaying both numeric and percentage formats:
Measure 1 (formatted)
Measure 2 (formatted)
You can then have copies of those, that are completly numeric:
Measure 3 (numeric)
Measure 4 (numeric)
You can then calculate a new measure 5, dependant on measure 3 & 4. Then you format measure 5 to match the formatting of 1 & 2.
Hope this helps,
J
Thanks for this! The perfect solution for what seems like a simple problem.
