Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 appointment figures for the current week and the previous week.
Please see tables below.
Any help greatly appreciated.
Solved! Go to Solution.
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
Hi @BryanWhellams,
Is there a possibility to not have data for a certain week(s). So, you may have data for 1701, 1702 and 1704. There is no data for 1703. Is this possible?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |