Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 |
Proud to be a Super User!
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 |
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |