Forum Discussion

tecumseh's avatar
tecumseh
Resolver III
9 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

     

tecumseh's avatar
tecumseh
Resolver III
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