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,
Kindly help me in getting the difference between two percentage columns (highlighted "cal util - tar util" )as mentioned in the attachment.
Attaching some junk file which i need to get differnce based on the file and it should not impact accuarcy even when i apply filters on the data.
https://drive.google.com/file/d/1XWB4cLAh6FYQe_c-t-Mlc61f03nGm9gi/view?usp=sharing
hi, @Anonymous
If [cal util] and [tar util] are measure, you could add a measure as below:
cal util - tar util = [cal util ] - [ tar util]
If [cal util] and [tar util] are columns, you could add a measure as below:
cal util - tar util = SUM('Table'[cal util]) - SUM('Table'[tar util])
Best Regards,
Lin
Cal util is a measure and tar util is a default column
Now suggest me how can i find the difference between them.
when i write above formula which you have provided it is not working correctly. Please find below the screenshots.
hi, @Anonymous
Could you share your simple sample pbix for us have a test?
Best Regards,
Lin
Hi @Anonymous ,
Did you try using Quick Measure? these steps below:
In the field panel, right click -> Hit on New quick measure-> pop up window appears, scroll down to the subtraction-> drag the values you want to use for your calculations
It should resolve your issue.
My output with quick measure:
Or
Measure to use:
Variance = SUM('Sheet1 (2)'[cal util]) - SUM('Sheet1 (2)'[tar util])
Let me know if this works.
Thanks,
Tejaswi
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |