convert serial dates to dates using M Script

[Anonymous]

Hi Experts

Sample data link: https://www.dropbox.com/s/szibko8edntt2ru/Test.pbix?dl=0

 
having a nightmare i am trying to convert several columns that are currently serieal dates as into date format dd/mm/yyyy
lets assumes the columns name are 
Column 1
Column 2 
column 3
in table MDR_TRANSLOG_LATEST
What do i need to add on the next line after MDR_TRANSLOG_LATEST1 = USER_MDR{[Name="MDR_TRANSLOG_LATEST"]}[Data],
 
MDR_TRANSLOG_LATEST1 = USER_MDR{[Name="MDR_TRANSLOG_LATEST"]}[Data],
in
MDR_TRANSLOG_LATEST1
 
DATE are values are coming in as text
41831
41524
etc..
 
i can convert this to date using DAX, but would like to add a step in Power Query. 
my dax

FORMAT( VALUE(MDR_TRANSLOG_LATEST[PR1_CREATION]),"dd/mm/yyyy")

[v-yuta-msft · Accepted solution]

@Anonymous ,

Have you tried the Date.From function as below?

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks Jimmy