DAX Query Returns Blanks Where Date Is Expected

[tecumseh]

Hi,

I expected dates in the highlighted columns, but DAX Query is returning blanks.
I want to control the format of the date when I copy/paste to Excel.
What am I doing wrong?

   "Booking_Date", FORMAT(SELECTEDVALUE(Bookings[Date]),"MM/DD/YYYY"),
   "Created_Date", FORMAT(SELECTEDVALUE(Bookings[Order Created]),"MM/DD/YYYY"),
   "Snapshot Date",FORMAT(TODAY(),"MM/DD/YYYY")

[tecumseh · Accepted solution]

Thanks @GilbertQ 

I ended up connecting from Excel using Analysis Services so I can format the dates in Power Query if neeed.
They imported as Date Time so changed data to Date - good to go.

Thanks,

w

[GilbertQ]

Hi @tecumseh 

One thing to note is if there is no data, Power BI will show it as blanks and that is why you are seeing the blanks. With regards to formatting your date. You actually need to format the date in your Power BI desktop report as shown below.