Forum Discussion

ApurvaKhatri's avatar
ApurvaKhatri
Icon for Helper III rankHelper 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
Icon for Community Support rankCommunity 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?