Excel Magic Trick 1443

DAX Formula for Sales Per Working Day: Power Pivot or Power BI Desktop


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 “Excel Magic Trick 1441-1448” Excel-Magic-Trick-1441-1448.zip – Downloaded 846 times – 3 MB

Be the first to comment

Leave a Reply