Forum Discussion
FORMAT DAX FUNCTION not working as expected
Month = FORMAT('Calendar'[Month Number],"mmm") This function is mapping month number 1 with "Dec" and all other month numbers (2-12) with "Jan" Please suggest possible solutio...
hi vishnugupta_
it seems you got data with different locale, or YYYY MM DD format.
change it in Power Query
https://www.myonlinetraininghub.com/change-type-using-locale-with-power-query