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.
I have 3 date filters, Month, Week and Day. Week starts from Sunday to Saturday.
Requirement: When I select 5th week of June, I want dates to be displayed from 26th June to 2nd July. Because 5th week of June starts from 26th June to 2nd July (7days).
But it is displaying data from 26th to 30th (last day of the month).
How do we achieve this?
Currently using below formula to get Weeknumber of the month
Weeknumberof Month = 1+WEEKNUM(Calender[Date])-WEEKNUM(STARTOFMONTH(Calender[Date]))
It sounds like you would need a custom column to count your weeks in the manner you are describing.
User | Count |
---|---|
93 | |
86 | |
68 | |
62 | |
58 |
User | Count |
---|---|
149 | |
113 | |
95 | |
80 | |
72 |