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.
Hello all,
I am currently trying to make graphs where I am able to drill down from Fiscal Year -> Fiscal Quarter -> Fiscal Month -> Fiscal Week; however, I am having issues figuring out code that can find the given week of a Quarter (1-13 using 445 calendaring) from a given date. The fiscal year I am working with is from May 1st - Apr 30th, so Q1 would be May, June and July so on and so forth.
In the below image, I found the Fiscal Year, Quarter and Month with functions on Excel, but I couldn't figure out the code for week so hopefully someone can do it via DAX. An example of an expected result using the below table would be 1/2/2018 = Week 5 and 2/6/2018 = Week 10
Any help/guidance would be much appreciated. Please let me know if you need any clarification.
Thanks
Solved! Go to Solution.
Hi @Anonymous
According to the calendar, January 2 is the first week. If you want him to show as the fifth week, you can add 4 after it. You can refer to my sample .
Measure = WEEKNUM(SELECTEDVALUE('Table'[Date]))+4
I have attached my pbix file .
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
According to the calendar, January 2 is the first week. If you want him to show as the fifth week, you can add 4 after it. You can refer to my sample .
Measure = WEEKNUM(SELECTEDVALUE('Table'[Date]))+4
I have attached my pbix file .
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Wee if the week code I have given here can help
https://amitchandak.medium.com/cheat-sheet-power-bi-4-4-4-and-4-4-5-calendar-786f76da7d92
Unfortunately, the outputted week numbers from your function aren't consistent with my companies fiscal weeks, so I can't use the code.
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 |
---|---|
54 | |
26 | |
23 | |
15 | |
9 |
User | Count |
---|---|
77 | |
61 | |
47 | |
17 | |
12 |