Forum Discussion
Solved
To fetch previous week data
I have a table viewKPI with column [todate] and [lease seated] I want to calculate sum([lease seated]) for last week from the column [todate]. How can I acheive this
Hi ApurvaKhatri,
You can create a measure below:
LastWeekTotal = CALCULATE(SUM(Table1[lease seated]),FILTER(ALL(Table1),WEEKNUM('Table1'[todate],1)=WEEKNUM(TODAY(),1)-1))
Best Regards,
Qiuyun Yu
Oddly, there is no PREVIOUSWEEK function. You would need to use a CALCULATE with an appropriate FILTER. I would use something like DATEADD with a -7 days in your filter. Again, oddly, the DATEADD function does not support weeks.
Can You please suggest DAx function with proper filter?