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: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

ImkeF

Number.Mod Bug

Submitted by Super User on ‎09-09-2017 07:47 AM

Number.Mod doesn't return that same than it's corrsponding functions in Excel and DAX when negative numbers are involved. I find this really bad.

Please change.

 

Current workaround:

(number, divisor) => if number>0 then number-Number.RoundDown(number/divisor,0) else Number.Abs(divisor)+number
Status: Accepted
See more ideas labeled with:
3 Comments (3 New)
Comments
v-haibl-msft
Employee
Employee
‎09-11-2017 11:33 PM

@ImkeF

 

I can repro the same issue as you. I’ve reported it internally to Power BI Team: CRI 46952686
I’ll post here once I get any update about it.

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎09-11-2017 11:34 PM
Status changed to: Accepted
 
v-haibl-msft
Employee
Employee
‎09-12-2017 06:56 PM

@ImkeF

 

I’ve got response from the Product Team.

 

We do not intend M to copy either Excel or DAX semantics. M has its own semantics and the current behavior is by design.

 

Best Regards,
Herbert

Idea Statuses