cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Helper II

## Unexpected modulo behavior

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
Super User

Hi @tkboisvert,

The way the formulas is calculated is slightly different between the two functions.

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!
3 REPLIES 3
Super User

@tkboisvert According to Modulo Calculator (calculators.org), Power Query is correct.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Super User

Hi @tkboisvert,

The way the formulas is calculated is slightly different between the two functions.

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!
Helper II

Thank you!