Power BI Buried Treasures: Modulo and Integer-Divide

This video will be the start of a new periodic series that I’d like to call “Power BI Buried Treasures”. I thought it’d be interesting to find a way to highlight functions and operators in Power BI that you may haven’t come across before, deeply buried in the menus, or those that you may have seen but don’t really know what they do.

For this video, I’d like to highlight the functions Modulo and Integer-Divide. Let’s take a look at how these functions can be useful to your reports.

Brian

***** Video Details *****
00:00 Introduction
00:54 Definitions
01:49 Data set
02:22 Using Modulo
03:50 Pivoting Modulo data
04:55 What Modulo did
05:45 Using Integer-Divide
07:52 Transposing data
08:42 Other uses of

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #Modulo #IntegerDivide