Forum Discussion

Vtomsons's avatar
Vtomsons
Icon for Helper I rankHelper I
6 years ago
Solved

Date Change from DD-MM-YYYY

I have one data source giving me trouble because it is DD-MM-YYYY formatted. When I change the data from text to date, Power BI is not consistent with numbers in the day or month column below 12. I n...
Need Help
  • Vtomsons's avatar
    Vtomsons
    6 years ago

    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's avatar
Vtomsons
Icon for Helper I rankHelper I
6 years ago

Thanks 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's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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 table
 
To 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