Direct Query convert date from mm/dd/yy to dd/mm/yy

[Anonymous]

HI need help to convert date from mm/dd/yy to dd/mm/yy in direct query. I was able to use below formula:

 Invoice Date  = IF(ISBLANK('Carton_V'[InvoiceDate]),BLANK(),DAY('Carton_V'[InvoiceDate])&"/"&MONTH('Carton_V'[InvoiceDate])&"/"&YEAR('Carton_V'[InvoiceDate]))

but the Invoice date is in text format and i need it in Date format so that i can use a slider filter for the date. 

I am using Direct Query. is there any other way?

Help please. 

[Anonymous · Accepted solution]

https://community.powerbi.com/t5/Service/Date-issue-dd-mm-yyyy-vs-mm-dd-yyyy/m-p/560625#M57419

You can refer to this thread for solution. 

Regards,

Paridhi