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
Sadly neither of the below had worked for me, but what did work was to create a new column in Power Query using Add Column - > Date -> Day - > START OF DAY.
Afterwards, I was able to use this new column to connect to my Date Table.