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_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")





Need Help
  • tecumseh's avatar
    tecumseh
    10 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

     

2 Replies

  • 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.

     

     

  • tecumseh's avatar
    tecumseh
    Icon for Resolver III rankResolver III
    10 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