How To Dynamically Compare First N Business Days In Power BI

For this video, Id 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 hadnt come across in exactly this form before, so Ive decided to make a miniseries exploring different ways to solve this problem. Lets 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 Whatif 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 How To Create A Holiday Table In Power BI