Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
I'm pretty new about PowerBI and its powerful features, so please forgive my question if it is so trivial and if I don't explain it very well.
I have a large visual in which it is displayed a table with three levels of column headers and their subtotals and grand total. They are all populated by three measure of Net amount (YTD, MTD, and punctual) The problem is that I want to add six more columns that are:
[Unificato][BER][progressivo] + [Speciale][BER][progressivo]
[Unificato][BER][progressivo-mese] + [Speciale][BER][progressivo-mese]
[Unificato][BER][puntuale] + [Speciale][BER][puntuale]
[Unificato][LUG][progressivo] + [Speciale][LUG][progressivo]
[Unificato][LUG][progressivo-mese] + [Speciale][LUG][progressivo-mese]
[Unificato][LUG][puntuale] + [Speciale][LUG][puntuale]
How can I achieve that? In more general way: how can I sum two columns in the report?
Thank you
Solved! Go to Solution.
If all this data is in the same table - just use 'New Column' to create each new calculation you need and add it to your matrix.
If they're different tables - do the same, but within a measure instead.
Thanks.
If all this data is in the same table - just use 'New Column' to create each new calculation you need and add it to your matrix.
If they're different tables - do the same, but within a measure instead.
Thanks.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |