Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Hydramh2
Frequent Visitor

Sum two columns of a report

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

aaaa.PNG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.