Forum Discussion
Helper IDate Change from DD-MM-YYYY
Thank you very much. My data is a little messed up right now after trying a few ways. I'll try your suggestion and let you know how it goes in the next few days.
Thanks so much for your time and advice.
Val
Memorable Member
Try changing the date to MM/dd/yyyy format if you could.
In Query Editor,Right Click in the column - Change Type-Using Locale - Select the Type (Date Time) and Select the Locale.
If this helps, mark it as a solution
Kudos are nice too
Helper IThanks but it didn't change anything.
Should I use some sort of Table? I really don't care for the exact day but I do want the month and year to be accurate.
Any other suggestions?
Val
- amitchandak
Super User
Try create a column like
new date =
mid(DD__MM__YY[Date],4,2) &"/"& left(DD__MM__YY[Date],2) & "/" & right(DD__MM__YY[Date],4)join it with date tableTo get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s.
Refer
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin - VasTg
Did you choose datatype as Date and United Kingdom(English). They follow dd/mm/yyyy format.
After that you could use Month or Year Dax function.
After that it will behave as regular date.
If this helps mark it as a solution
Kudos are nice too
- Vtomsons
Thank you very much. My data is a little messed up right now after trying a few ways. I'll try your suggestion and let you know how it goes in the next few days.
Thanks so much for your time and advice.
Val
- Vtomsons
Looks like the 2nd solution worked. I was not linking to UK English like you suggested.
Thanks a ton.
Val
