Custom column how do i convert date (mm/dd/yyyy) to a serial number?

Question

Good day is there a way to convert a column [date] (dd/mm/yyyy) to serial number in power query, just as the regular excel do when the column is formatted as general. I do need to get the serial number and concatenate it with [id number] because ill use it as a lookup value.

i need the output like the one on "WE+Entity ID" header

anonymous · Accepted Answer

If your last step or Table name is "Table1", then just make a new step, and in the formula bar, type:

=Table.TransformColumns(Table1, {{"date", Number.From}})

You can concatenate if you then change the date number to text.

--Nate

Forum Discussion

Custom column how do i convert date (mm/dd/yyyy) to a serial number?

2 Replies

Related content

Date Formats - MM/DD/YYYY to DD/MM/YYYY

how to change date format --- mm-dd-yyyy to dd-mm-yyyy in power bi

Date issue - dd/mm/yyyy vs mm/dd/yyyy

unable to change date format mm/dd/yyyy to dd/mm/yyyy

Converting "DD/MM/YYYY" & "MM/DD/YYYY" date Type to DD/MM/YYYY