Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
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
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
Show the code for "Added Custom"
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
27 | |
26 | |
22 | |
12 | |
10 |
User | Count |
---|---|
27 | |
25 | |
22 | |
18 | |
13 |