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