Forum Discussion
Tony88
Helper I
4 years agoHow 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 le...
- 4 years ago
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
Tony88
Helper I
4 years agoThank you, this is what I want.