For this video, let’s go back to a mini-series I recently started that explores different ways to solve a problem from an Enterprise DNA forum entry asking how to compare data by billable days instead of calendar days. This is quite an interesting question that I hadn’t come across in exactly this form before. Let’s go through how I would personally approach this problem using DAX

Brian

***** Video Details *****
00:00 Introduction
01:35 Overview of solution
02:08 The measure
03:40 Dates[IsBusinessDay] filter
04:30 Two table input
05:24 TOPN
07:27 GENERATE
09:55 What-if parameter

***** Related Links *****
Compare Data By Working/Billable Days Not Calendar Days at the Enterprise DNA Forum – https://forum.enterprisedna.co/t/compare-data-by-working-billable-days-not-calendar-days/20649
How To Dynamically Compare First N Business Days In Power BI – https://youtu.be/AzmDrmFSg-U
Generate DAX Function – https://dax.guide/generate/

***** 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 #DAX #DAXTutorial