Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Here's a fun one - created a Dax calendar using CALENDARAUTO(12)
Added a column using: Month = FORMAT(DatesDAX[Date], "MMMM")
Added a column using: WeekNum = WEEKNUM('DatesDAX'[Date].[Date])
Put them into a hierarcy to get the following visual:
The only issue is that because the week numbers exist in both months - it's doubling the data for those crossover weeks(27,31,36).
Any ideas how I can clean this up?
Thank you!
Yes, don't mix months and weeks. They do not work well together.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |