Forum Discussion
Last 3 Week Sales returning blank when current week is empty
Hi all! Hope you can help with this, I have a measure to add up sales of last 3 weeks, the measure is : _P3 = CALCULATE(SUM(Dashboard_Weekly[Value]),DATESBETWEEN(Dashboard_Weekly[Week],[_L3W],[_This...
Hi aavilap
Try this formula
Measure = CALCULATE(SUM(Sheet7[current]),DATESINPERIOD(Sheet7[date],MAX(Sheet7[date]),-21,DAY),ALL(Sheet7))
Best Regards
Maggie
Thanks v-juanli-msft! I have managed to solve it by creating an independent dates table and creating the relation between my Data table and this new dates table.