Forum Discussion
Mahipal
Helper I
Helper IConverting from datatype Date/Time column to Date using DAX in Direct query
Hello Everyone, We are using a column which is date/time datatype. Which we need to use to create date column using the DAX expression with calculated column in Direct Query. Joining date- 3/6/2...
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.
MahipalHelper I
Helper IDATEVALUE(), REPT(),FORMAT() and few more functions are not working for Directquery mode.