Forum Discussion
Incorrect Month
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 MonthNumber = MONTH ( 'Date'[Date] ...
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