I am trying to create a DAX measure that returns the last 4 weeks Sales.
My powerpivot has a separate calendar table which is linked to the sales table by the date, the calendar in turn has a column that indicates the rolling period that the date in question belongs to. My aim is to sum all sales where the saledate has a 4 in
the rolling period column for the corresponding date.
My attempt was:
=CALCULATE(SUM('Sales Data'[Sales Ex GST]),RELATED(Calendar[Rolling Weeks])="4")
Which doesn't work! Any help most appreciated!
Jacob