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 Experts
I have a matrix table, in that based on my output column I need to sum from two columns. could you please help me how to do that.
there are three columns selected. Let me know if need any further details
In the same matrix table, I need a new column which is CF - FL = Output.
Category | Actuals | Plan | CF | FL | CF - FL |
CA | 79977 | 13481 | 176283 | 899932 | |
CD | 49817 | 13683 | 125146 | 553024 | |
CDT | 56014 | 13483 | 123338 | 595184 | |
CDPL | 52788 | 855834 | 127691 | 596230 | |
CM | 18833 | 508201 | 127691 | 33 | |
ROW | Category | ||||
Column | Ver | ||||
Values | Revenue |
If you are talking about the matrix visualisation, then I think you'd need a new measure rather than new calculated column. Which would be something like:
CF - FL := var cf = calculate(sum(revenue);ver="CF") var fl = calculate(sum(revenue);ver="FL") return cf-fl
If you are talking about power query side of things, then you'd need to make new column in PowerQuery -> Add column -> select CF -> From number -> standad -> substract -> choose FL.
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 |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |