problem with convert date column from query

[Anonymous]

hello!

I used MS documentation https://docs.microsoft.com/en-us/azure/devops/report/powerbi/sample-boards-leadcycletime?view=azure-... for calculate Cycle time, but have problem with incorrect date value, in default date value is (example) "20201025" (25th October). How does it convert to normal date format or workarround solution. 

[lkalawski · Accepted solution]

Hi @Anonymous 

Try this code:

=DATE(INT(LEFT([CompletedDateSK],4)),INT(MID([CompletedDateSK],5,2)),INT(RIGHT([CompletedDateSK],2)))

_______________
If I helped, please accept the solution and give kudos! 😀