Hi DNA Team,
I need some help on this silently different percentage change calculation.
I have completed a simple Percentage Change Measure in the Attached PBIX file. Percent Change.pbix (30.3 KB)
By way of example, I would like a measure that takes the percentage change calculated and presents it in an opposite manner , for instance:
if the % Change equalled 0% then it would equals 100%.
or if % Change equalled 1% then it would equal 99%.
or if % Change equalled 2% then it would equal 98%…and so on…
If you can demonstrate this in the PBIX file that would be great.!