Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi all,
I've been browsing the internet for ways to show the current week of any given month but all I've come across is week number of the year. Is it possible to show week of the month? For instance, instead of week 31/32, it would be week 1 of August. This may pose a problem if weeks carryover from one month to another though. See my screenshot below for how it currently looks. Also, my existing DAX query is also below:
DAX formula:
Week = " Week " & WEEKNUM(VendDisplay[DateCreated], 2) & " - " & FORMAT(VendDisplay[DateCreated], "MMMM")
Any help is appreciated as always. Thanks!
Regards,
Derek
Solved! Go to Solution.
Hi @jderekc,
Try this column:
Week = " Week " & 1 + WEEKNUM ( VendDisplay[DateCreated] ) – WEEKNUM ( STARTOFMONTH ( VendDisplay[DateCreated] ) ) & " - " FORMAT(VendDisplay[DateCreated], "MMM")
If not works, my recomendation is to use a Calendar table linked to VendDisplay[DateCreated], and then change VendDisplay[DateCreated] to Calendar[Date] in this formula.
Hi @jderekc,
Try this column:
Week = " Week " & 1 + WEEKNUM ( VendDisplay[DateCreated] ) – WEEKNUM ( STARTOFMONTH ( VendDisplay[DateCreated] ) ) & " - " FORMAT(VendDisplay[DateCreated], "MMM")
If not works, my recomendation is to use a Calendar table linked to VendDisplay[DateCreated], and then change VendDisplay[DateCreated] to Calendar[Date] in this formula.
You are a genius, @Anonymous! I did it and now my bar chart returns "Week 1 - Aug", "Week 2 - Aug", et cetera. I did have to reformat the DAX formula just a little bit because it gave me an issue that completely failed its execution, but it was just a minor tweak. Thanks so much!
Regards,
Derek
It was missing an &. I adjusted it below and it worked fantatstic for me.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
63 | |
52 | |
47 |
User | Count |
---|---|
215 | |
85 | |
61 | |
61 | |
60 |