Forum Discussion

BryanWhellams's avatar
BryanWhellams
Frequent Visitor
8 years ago
Solved

Previous Week Figures Using Calendar Table

Hi all   I am trying to get the previous weeks figures based on the week in a calendar table.   Specifically I want to be able to create a table that uses the dates from the calendar table to get...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi BryanWhellams,

     

    You can create measures below: 

     

    CurrentWeekTotal = CALCULATE(SUM(Table1[Appointments]),FILTER(ALL(Table1),'Table1'[WeekNumber]=MAX('Calendar'[Weeknum])))

     

    PreviousWeekTotal = CALCULATE(SUM(Table1[Appointments]),FILTER(ALL(Table1),'Table1'[WeekNumber]=MAX('Calendar'[Weeknum])-1))

     

     

    For details, you can download attached pbix file. 

     

    Best Regards,
    Qiuyun Yu 

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

Hi BryanWhellams,

 

You can create measures below: 

 

CurrentWeekTotal = CALCULATE(SUM(Table1[Appointments]),FILTER(ALL(Table1),'Table1'[WeekNumber]=MAX('Calendar'[Weeknum])))

 

PreviousWeekTotal = CALCULATE(SUM(Table1[Appointments]),FILTER(ALL(Table1),'Table1'[WeekNumber]=MAX('Calendar'[Weeknum])-1))

 

 

For details, you can download attached pbix file. 

 

Best Regards,
Qiuyun Yu