For this video, I’d like to do a walkthrough on a solution I developed for a recent entry in the Enterprise DNA forum 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, so I’ve decided to make a mini-series exploring different ways to solve this problem. Let’s go through how I would personally approach this problem using Power Query.

Brian

***** Video Details *****
00:00 Introduction
01:36 Data set
04:01 Duplicate table
04:45 1st Group By
05:30 Merge tables
06:15 Fields selection
07:01 Ascending order date
07:07 2nd Group By
07:35 AllRows
08:16 Custom column
12:02 What-if parameter
13:38 Total Sales N Bus Days 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 Create A Holiday Table In Power BI – https://youtu.be/v9s0PPLU0n8

***** 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 #PowerQuery #PowerQueryTutorial