March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
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! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
61 | |
55 | |
26 | |
17 | |
13 |