Hi all,
In excel, I have this formula:
MOD(-10 + 9,12) + 1
And the expected result is 12
However, in PowerQuery the same formula:
Number.Mod(-10 + 9, 12) + 1
Results in 0
The strange thing is that for other numbers ( -1 ) I get the same result in both systems..
I expect this to have something to do with the nature of MOD, and how I'm using negative numbers.. But I would still like to know which is 'correct'..
1 ACCEPTED SOLUTION
Hi @tkboisvert,
The way the formulas is calculated is slightly different between the two functions.
Check out this video: https://www.youtube.com/watch?v=K4ImPRsi3vg&ab_channel=ExcelIsFun
Kim
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. |
Proud to be a Super User!
@tkboisvert According to Modulo Calculator (calculators.org), Power Query is correct.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Hi @tkboisvert,
The way the formulas is calculated is slightly different between the two functions.
Check out this video: https://www.youtube.com/watch?v=K4ImPRsi3vg&ab_channel=ExcelIsFun
Kim
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. |
Proud to be a Super User!
Helpful resources
Fabric Data Days 2026
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
