Forum Discussion
Convert 5-digits to yyyy/mm/dd
Hello! I'm wondering how I can convert 5-digit number to date type. I'm new to using PowerBI and utilizing an excel data so that would be nice if I can get some help from you guys! So I have 5 d...
Idrissshatila
Super User
Super UserHello machi0604 ,
What I would tell you that, it's better to perform the transformation on the data source than to do it in Power BI.
Also as you said, Power BI Would recognise it as 2018/09/01, so prepare it right in Excel then import the data prepared.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍