convert date to text

[Jeanxyz]

I want to create a key column Source_Target_Date in the format of  USD_USD_10/18/2022. Below is what I get, how can I avoid the "-" symbol in the column?

[mangaus1111]

Hi @Jeanxyz ,

for me it works easily. I think that is important that you don´t change the data type in Power Query from date to text.

[Arul]

@Jeanxyz ,

This may help you,

Source_Target_Date = [Converted Currency]&"_"&[Budget Currency]&"_"&FORMAT([DateID],"DDMMYYYY")

Thanks, 

[Samarth_18]

Hi @Jeanxyz ,

You can try like this:-

Column = 'Table'[Converted currency]&"_"&'Table'[budget currency]&"_"&FORMAT('Table'[dateid],"MM/DD/YYYY")

[Jeanxyz · Accepted solution]

I tried the DAX below and get AUD_AUD_10-18-2022.  

Column = 'Table'[Converted currency]&"_"&'Table'[budget currency]&"_"&FORMAT('Table'[dateid],"MM/DD/YYYY")

 Below is how I solve the problem. However, it's a bit complicated, so I was hoping there is an easier solution. 

Source_Target_Date = [Converted Currency]&"_"&[Budget Currency] &"_"&format(month([DateID]),"0#") &"/"&format(day([DateID]),"0#") &"/"&year([DateID])