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.
Hello,
I'm trying to create a column with custom week numbers (Operating periods) that end in the dates below:
1/1/2022 - 1/12/2022 - Week 1
1/13/2022 - 1/19/2022 - Week 2
1/20/2022 - 1/26/2022 - Week 3
Until the last week of the year.
Any ideas on how I can accomplish this? I a pprecite your help!
Solved! Go to Solution.
To close the loop on this, this is what ended up working:
Operating Period = WEEKNUM('Calendar'[Date]+4, 21)-1
It gave me this:
To correct the first 5 days of the week that defaulted to Operating Period 0, I added this:
Operating Periods = if('Calendar'[Operating Period] = 0,1,WEEKNUM('Calendar'[Date]+4, 21)-1)
The result was this, which is what I needed:
To close the loop on this, this is what ended up working:
Operating Period = WEEKNUM('Calendar'[Date]+4, 21)-1
It gave me this:
To correct the first 5 days of the week that defaulted to Operating Period 0, I added this:
Operating Periods = if('Calendar'[Operating Period] = 0,1,WEEKNUM('Calendar'[Date]+4, 21)-1)
The result was this, which is what I needed:
@NPC What is the pattern? Is the first week 1/1 - 1/12 and then each week is the next 7 days? You could do something like maybe: WEEKNUM([Date],14) ? 14 starts weeks on Thursday.
Unfortunatley with this approach week 1 ends on 1/5. To answer your question though, yes - each week is the next 7 days after the first 12 days of the year.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
39 | |
33 | |
31 | |
25 |