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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

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