Forum Discussion
Tony88
Helper I
Helper IHow do I change below numbers to date format?
Hello,
Hope you all having a nice weekend! I am trying to convert the below numbers to date format. I tried giving a date or date/time on the format. It giving me an error. Can anybody please let me know how to change to date?
20191009
Thank you
Tony
Try this - https://stackoverflow.com/questions/48061351/power-bi-convert-eight-digit-yyyymmdd-to-date-using-dax
- just make the yyyymmdd column a text column
- make the text column from step 1 a date column (when prompted, be sure to select 'Add New Step')
- replace errors with null
3 Replies
ShahfaisalSolution Sage
Try this - https://stackoverflow.com/questions/48061351/power-bi-convert-eight-digit-yyyymmdd-to-date-using-dax
- just make the yyyymmdd column a text column
- make the text column from step 1 a date column (when prompted, be sure to select 'Add New Step')
- replace errors with null
Tony88Thank you, this is what I want.
- Tony88
Shahfaisal Thank you so much. That works.