These are the sample DAX functions, we can use to generate Last Month, This Month and Last Week and This week. Then use a Clustered Column chart to add all the measurements.
Last Month = CALCULATE(SUM(Sheet1[Sales Value]), FILTER(ALL(Sheet1), YEAR(Sheet1[Sales Date]) = YEAR(TODAY()) && MONTH(Sheet1[Sales Date])= MONTH(TODAY())-1))
This Month = CALCULATE(SUM(Sheet1[Sales Value]), FILTER(ALL(Sheet1), YEAR(Sheet1[Sales Date]) = YEAR(TODAY()) && MONTH(Sheet1[Sales Date])= MONTH(TODAY())))
Last Week = CALCULATE(SUM(Sheet1[Sales Value]), FILTER(ALL(Sheet1), YEAR(Sheet1[Sales Date]) = YEAR(TODAY()) && WEEKNUM(Sheet1[Sales Date])= WEEKNUM(TODAY())-1))
This Week = CALCULATE(SUM(Sheet1[Sales Value]), FILTER(ALL(Sheet1), YEAR(Sheet1[Sales Date]) = YEAR(TODAY()) && WEEKNUM(Sheet1[Sales Date])= WEEKNUM(TODAY())))
Comments
Post a Comment