Videos about Excel Microsoft Power BI Desktop from Mike excelisfun Girvin at Highline College.
Curated by: excelisfun (61 videos)
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