Learn how to calculate Sales per working day based on a Data Model with Sales and Data Table. See the DAX Functions: CALCULATE, COUNTROWS, SUM, CROSSJOIN, VALUES, SUMX, IF, FILTER and MAX. Learn how to create an internal table using the CROSSJOIN function, that SUMX can iterate over to calculate the Correct number of working days for each date period on the Report Filter Context.
Download File:
Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1443Start.xlsx
Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1443Finished.xlsx
Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm