• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Resources
    • DAX Glossary
    • Download Center
    • Template Apps
    • Data Stories Gallery
    • Solution Gallery
    • Learning Resources
  • Courses
    • Introduction to Power BI – FREE Online course
    • Power Query Online Training for Power BI
    • M Language Online Course: The unofficial and Practical Reference Guide
  • Blog
  • Shop
    • Courses
    • Swag
    • Template Apps
    • Donations
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Contact
You are here: Home / CM Tooltip Glossary Pro+ / MOD

MOD

posted on August 30, 2019

« Back to Glossary Index

Syntax

MOD(<number>, <divisor>)

Tutorial with example

MOD function returns the remainder (the decimal numbers) after a number is divided by a divisor. The result always has the same sign as the divisor.

In this video, I am going to show your how to calculate how late are your employees and how much would you discount of the payroll if you had a 2$ fee for each 15 min late using among others MOD function.

Keynotes:
03:00 Calculate how many minutes or hours and employee is late with DATEDIFF function
05:00 Calculate how many 15 minutes interval he is late : QUOTIENT function
10:00 Extract minutes from a time column in DAX: TIMEVALUE and MINUTE funcitons
12:00 Extract decimals from a number with MOD function
13:20 Convert a number to a logical function : true or false with INT function
14:00 Calculate payroll fee if employee is late

 

Download example files:

Download the pbix and excel file here.

Remarks

If the divisor is 0 (zero), MOD returns an error. You cannot divide by 0.

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

Was this helpful?
[Total: 0   Average: 0/5]
See Also:
  • MINUTE
  • TIMEVALUE
« Back to Index

Reader Interactions

Let us know your thoughts... Cancel reply

Footer CTA

Join our community of +20,000 professionals

Become a Member

Subscribe to YouTube

About us

Curbal AB
Kopparbergsvägen, 10
722 13 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2021 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In