Forum Discussion

tecumseh's avatar
tecumseh
Icon for Resolver III rankResolver III
10 months ago
Solved

DAX Query Returns Blanks Where Date Is Expected

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_...
Need Help
  • tecumseh's avatar
    tecumseh
    9 months ago

    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's avatar
GilbertQ
Icon for Super User rankSuper User
10 months ago

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.