skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
    • Dynamics 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Getting started
      • Overview
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Microsoft Power BI Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power BI
    • Desktop
    • Service
    • Report Server
    • Power Query
    • Mobile Apps
    • Developer
    • DAX Commands and Tips
    • Custom Visuals Development Discussion
    • Health and Life Sciences
    • Power BI Spanish Community
    • Translated Spanish Desktop
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Training and Consulting
    • Instructor Led Training
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    • Ideas
    • Custom Visuals Ideas
    • Issues
    • Issues
    • Events
    • Upcoming Events
    • Community Engagement
    • T-Shirt Design Challenge 2023
    • Community Blog
    • Power BI Community Blog
    • Custom Visuals Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    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: 
    • Microsoft Power BI Community
    • Galleries
    • Quick Measures Gallery
    • To **bleep** with MOD

    To **bleep** with MOD

    05-08-2020 11:07 AM - last edited 05-12-2020 09:48 AM

    Super User Greg_Deckler
    Super User
    2009 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Greg_Deckler
    Super User Greg_Deckler
    Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    To **bleep** with MOD

    ‎05-08-2020 11:07 AM

    @az38 gets all the credit for this one. He noticed a peculiar behavior of MOD and reached out to me in my series on Excel to DAX Translation (L-M). Read the thread and original issue. The bottom line though is that MOD in DAX is broken. The good news I suppose is that it doesn't suck any worse than the Excel version. Now, there are some possible explanations:

    • https://answers.microsoft.com/en-us/office/forum/office_2010-excel/problem-with-the-mod-function-in-...
    • https://docs.microsoft.com/en-us/office/troubleshoot/excel/floating-point-arithmetic-inaccurate-resu...

    Or you could point to the documentation on MOD and say that it specifies a return value of a whole number. But, let's be honest, that is all BS and garbage. There is no reason under the sun that MOD should not work with decimal numbers. Especially when the solution is right in the documentation:

     

    The MOD function can be expressed in terms of the INT function: MOD(n, d) = n - d*INT(n/d)

     

    Um, first of all, WRONG! Because it just so happens that the alternate version of expressing MOD actually WORKS!! So, you can't put that equivalency in your documentation because those two things do not equal one another. So to **bleep** with MOD! We don't need it!

     

     

    ToHellwithMOD = 
        VAR __Value = MAX('Table'[Value])
        VAR __Divisor = [Divisor Value]
    RETURN
        __Value -__Divisor * INT( DIVIDE(__Value, __Divisor) )

     

     

     

     

    eyJrIjoiZDUyMmU3MWYtNTk0NS00MzFhLWE4YTctMmYyOTQ4YmVjZjI2IiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9


    @ 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!:
    Mastering Power BI 2nd Edition

    DAX is easy, CALCULATE makes DAX hard...
    Preview file
    115 KB
    ToHellWithMOD.pbix
    Labels:
    • Labels:
    • Mathematical
    Message 1 of 2
    2,009 Views
    3
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    jeroenterheerdt
    Microsoft jeroenterheerdt
    Microsoft
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎06-18-2020 03:34 PM

    Hi Greg,

     

    thanks for sharing this. I just wanted to let you know that we are aware of the issue and we do have an item on the backlog for it. There is no ETA yet as we are dependent on some other teams.

     

     

    Message 2 of 2
    1,658 Views
    0
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices