Date format for direct query merged column

in power bi, in direct query mode, I have created a merged column which have three columns. one of the column is a date column. but since its a merged column, the date column also act as text. so its formating is not dd/mm/yyyy its in yyyy-mm-dd format now. how to resolve this.

I have attached the merged column Reference. First part of the column is a number then the date part(highlighted) then a code.

If i give the same date column outside the merged column its showing in the correct format dd/mm/yyyy. Only inside the merged column its showing like yyyy-mm-dd. I need it in dd/mm/yyyy.

FORMAT function I have tried and its not working in direct query mode.