Forum Discussion
vjnvinod
4 years agoImpactful Individual
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] ...
mahoneypat
4 years agoMicrosoft Employee
- vjnvinod4 years agoImpactful Individual
544 with the 52-week calendar is what I am trying to build?
Do you have a sample pbix you have handy to use?
- mahoneypat4 years agoMicrosoft Employee
Are you comfortable adapting the M code from that article to meet your needs? It shouldn't take much I think.
Pat
- vjnvinod4 years agoImpactful Individual
I can try, but what happens to those M Code next year? will that work?