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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
zraopingm
Helper III
Helper III

ADDED COLUMN DOES NOT CALCULATED CORRECTLY

Hello, this is in Power Query environment:

I have period 12 and 9, trying to see the difference by adding a cusomer column = 12-9

but not all rows are correctly calculated the difference.. not sure why?

thank you for your input

Zoey

 

zraopingm_0-1728398476231.png

 

 

1 ACCEPTED SOLUTION

8 REPLIES 8
zraopingm
Helper III
Helper III

@lbendlin 

thank you.. it seems only where the value is null, it does not work. that is why I replace null with 0

thank you

Zoey

zraopingm_0-1728402003617.png

 

ls.png

thank you list.sum works! but why a straight forward col12-col9 does not work though? I will research on this further.

thank you

Zoey

that is a good read,

thank you 

Zoey

Can you try to change your column names so they do not start with a number?

thank you it does not work, but AlienSX suggested to use list.sum, it works. 

Thank you for your time.

Zoey

lbendlin
Super User
Super User

Show the code for "Added Custom"

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

October NL Carousel

Fabric Community Update - October 2024

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