Forum Discussion
aarikc17
Advocate I
Advocate IDate Format Direct Query
I am using a direct query and I cannot use the formatting options for a date. I am trying to create a report that shows when a unit is supposed to start (DD/MM/YYYY). However, my data from my...
I found this........ it worked........
https://community.powerbi.com/t5/Desktop/Unable-to-alter-number-formatting/td-p/38134
You can create a column
Date=LEFT('Table'Datetime,10)
the above column trims to 10 characters which is in DD/MM/YYYY format and you can change datatype of the column to date