Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Month() and Day() Functions Replacing values!

Hey everybody.

 

I've created a function to count days between two different measures.

 

I have a measure - Today_Updater - showing the last date in my datedim table.

 

All of the dates are in "DD/MM/YYYY" format.

 

I've noticed that in the current month, Day() and Month() function for some unknown reason between the 8th of July and the 12th of July Day() gives the month and Month() gives back the day...

 

I am super frustrated... my region is set, all date formats are good... but still...   attached below are the screenshots:

 

On the 7th all is good

Between the 8th to the 12th for some reason, the Day() gets the month's number and Month() the day's number

 

On the 13th, it is back to normal. I really cannot understand why.

It happens every single year, between the 8th and the 12th.

 

Please help me solve this problem, I have zero clues about how to solve this.

 

Thanks a lot!

1 Reply

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support

    Hi Anonymous ,

     

    The date show the format of MM/DD/YYYY by default in Power BI. You can change the option to DD-MMM-YY. 

    Best Regards,

    Xue Ding 

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.