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"

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

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