Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
tkboisvert
Helper II
Helper II

Unexpected modulo behavior

‎09-22-2021 04:19 PM
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'..
 
tkboisvert_0-1632352753075.png

 

 
Labels:
Message 1 of 4
3,900 Views
0
1 ACCEPTED SOLUTION
KNP
Super User
Super User

‎09-22-2021 05:05 PM

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 ;).		xOIEmaj

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.
image		fabric-SUbadge
Proud to be a Super User!

View solution in original post

Message 2 of 4
3,854 Views
3 REPLIES 3
Greg_Deckler
Community Champion
Community Champion

‎09-22-2021 06:14 PM

@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...
Message 4 of 4
3,831 Views
0
KNP
Super User
Super User

‎09-22-2021 05:05 PM

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 ;).		xOIEmaj

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.
image		fabric-SUbadge
Proud to be a Super User!
Message 2 of 4
3,855 Views
tkboisvert
Helper II
Helper II
In response to KNP

‎09-23-2021 08:16 AM

Thank you!

 

Message 3 of 4
3,800 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All