Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I'm trying to get % Difference between columns as sample below. Tried different methods but getting wrong results.
Col A | Col B | Col C | Difference |
Jul | 95% | 99% | 4% |
Aug | 97% | 90% | -7% |
Sept | 80% | 100% | 20% |
Please suggest a way for getting the correct results. Thanks for checking.
Solved! Go to Solution.
@AN_PBI ,
I am attaching screen shot and PBIX file with expected output.
@AN_PBI ,
I am attaching screen shot and PBIX file with expected output.
@AN_PBI , If these are columns
Difference = [Col C] - [Col B]
If B and C are % column Mark Difference also a Percent column
if they are a measure
Difference = [Col C] - [Col B]// All are meausres
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |