DESCRIPTION
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.
WORKBOOKS
Download “Excel Magic Trick 1441-1448” Excel-Magic-Trick-1441-1448.zip – Downloaded 97 times – 3 MB
Leave a Reply
You must be logged in to post a comment.