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.
I am seeing some issues with my calendar table
Week5 is technically should be P01, but its shown as P02
this is the formula I am using for month number
Hi, @vjnvinod ;
Hi, @vjnvinod ;
You could try it.
MonthNumber =
MONTH ( 'Date'[Week End] )
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please see if this calendar table is useful.
445 Calendar with 53-Week Years – Hoosier BI
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
544 with the 52-week calendar is what I am trying to build?
Do you have a sample pbix you have handy to use?
Are you comfortable adapting the M code from that article to meet your needs? It shouldn't take much I think.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
I can try, but what happens to those M Code next year? will that work?
Not sure what you mean, but a simpler solution might be to add a column with this expression to your existing Date table query. You can adapt if you week starts on a different day, but this will calculate the fiscal month based on the month of the first day of that week.
= Date.Month(Date.StartOfWeek([Date], Day.Sunday))
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |