Adding Multiple Date Measurements to One Visualization in Power BI

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