Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
4 years ago

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] ...
Need Help
Show and Tell
vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
4 years ago

mahoneypat 

I can try, but what happens to those M Code next year? will that work?

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

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