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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Mederic
Helper V
Helper V

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

Just Add a Custom Column:

 

Name: Result

Formula: = [Debit] + [Credit]

View solution in original post

4 REPLIES 4
Mederic
Helper V
Helper V

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

ronrsnfld
Super User
Super User

Just Add a Custom Column:

 

Name: Result

Formula: = [Debit] + [Credit]

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

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors