Custom Column - Concat with Date displayed as a number (eg: 26/06/2019 as 43638)

[IrishChristof]

Hi guys,

I'm trying to create a unique field on my table in Power Query that concatenates a Tour Code and Departure Date, but I need the date to be displayed as a number.

I tried the Date.ToText method but cant seem to get it going.

= [Tour Code] & Date.ToText([Departure Date] , "#####")  ???

Help

[AnthonyTilley · Accepted solution]

for your date use the value function to get the date as a number 

you can then concat this with any text value from another colunm

Column = "TEST - " & VALUE('Table'[Column1])

01 January 2019	TEST - 43466
01 February 2019	TEST - 43497
01 March 2019	TEST - 43525