cancel
Showing results for
Did you mean:
Highlighted
Member

## 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

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

## Re: To fetch previous week data

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Super User

## Re: To fetch previous week data

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.

Proud to be a Datanaut!

Member

## Re: To fetch previous week data

Can You please suggest DAx function with proper filter?

Moderator

## Re: To fetch previous week data

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member

## Re: To fetch previous week data

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.