To fetch previous week data

[ApurvaKhatri]

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

[v-qiuyu-msft · Accepted solution]

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 

[Anonymous]

What if it is weeknum 1 and we need weeknum 52?

[ApurvaKhatri]

Hi.. Thanks for the reply.

Can you explain the signigicance of -1 in the formule.

Actually, I am trying to hardcode values of previous 12 weeks data starting from today and going back 12 weeks fo every column.

e.g:

                            16thoct   9thoct   2ndoct  25thsept ..... till 12 weeks

Total Salary          ....              ....         ....

Thanks,

Apurva Khatri.

[Greg_Deckler]

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.

[ApurvaKhatri]

Can You please suggest DAx function with proper filter?