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
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi,  vjnvinod ；

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we could close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

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.
  • vjnvinod's avatar
    vjnvinod
    Icon for Impactful Individual rankImpactful Individual
    4 years ago

    v-yalanwu-msft 

     

    i managed to get this resolved by using

    Month number and week start date combination