Reply
Mederic
Post Patron
Post Patron
Partially syndicated - Outbound

Merge 2 columns thar contain zéros

Hello

I found this interesting tip which works with columns when the values contain null
In this example I would like to keep the zeros and the code doesn't work.
Is there a trick that doesn't require an if ?

Thanks in advance

 

Best regards

 

 

 

Debit	Credit
12	0
45	0
0	21
52	0
19	0
85	0

 

 

 

Merge 2 Columns.jpg

1 ACCEPTED SOLUTION
ronrsnfld
Super User
Super User

Syndicated - Outbound

Just Add a Custom Column:

 

Name: Result

Formula: = [Debit] + [Credit]

View solution in original post

4 REPLIES 4
Mederic
Post Patron
Post Patron

Syndicated - Outbound

Yes, it's a great way to learn and one that you'll never forget,
Thank you

ronrsnfld
Super User
Super User

Syndicated - Outbound

Just Add a Custom Column:

 

Name: Result

Formula: = [Debit] + [Credit]

Syndicated - Outbound

Hello @ronrsnfld 

I'm ashamed when I see the solution and I say to myself, why didn't I think of this  😀

Thank you

Best regards

Syndicated - Outbound

I have done many "head slaps" over the years.

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)