Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello I have a column with Whole number like 20190106, when I try to convert that to Date it give me an error. How can I covert above whole number to YYYY/MM/DD format?
Thanks
Solved! Go to Solution.
Hi @sabeensp
Did you try adding M code like this?
Or you can also try this new column:
Column = Date(Left([data],4),Right(left([data],6),2),right([data],2)
and then change the data type of new column to Date
Let me know if thsi works.
Thanks,
Tejaswi
Hi @sabeensp ,
Take a look at this post. The issue is already resolved in this post.
https://community.powerbi.com/t5/Desktop/date-from-yyyymmdd-stored-as-whole-number/td-p/92689
Thanks,
Tejaswi
@Anonymous M code not working for me somehow, when I add a new calcualted column. Is there another way?
Hi @sabeensp ,
There are two Solutions in this post.
Did you try the second one. Hope that works for you.
Thanks,
Tejaswi
Hi @sabeensp
Did you try adding M code like this?
Or you can also try this new column:
Column = Date(Left([data],4),Right(left([data],6),2),right([data],2)
and then change the data type of new column to Date
Let me know if thsi works.
Thanks,
Tejaswi
@Anonymous problem with the 2nd solution is that I have over 15 Date columns, divide them into YY, MM, DD would result in 45 columns. I was hoping for some DAX formula to convert
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |