Forum Discussion

ApurvaKhatri's avatar
ApurvaKhatri
Helper III
8 years ago
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
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    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 

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

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

  • ApurvaKhatri's avatar
    ApurvaKhatri
    Helper III
    8 years ago

    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.