Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
68 | |
67 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |