Converting from datatype Date/Time column to Date using DAX in Direct query

Hi Mahipal ,

Please try the following methods and check if they can solve your problem:

1.Create the simple table. Click on Transform Data.

2.Create the custom column to convert the Date/Time column to Date type.

= Text.From(Date.Month([Joining date]))&"/"&Text.From(Date.Day([Joining date]))&"/"&Text.From(Date.Year([Joining date]))

3.The Date type custom is shown below.

Solved: Change date format in DIRECT Query Mode - not on l... - Microsoft Fabric Community

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.