Forum Discussion

Divya904's avatar
Divya904
Helper III
8 years ago

Remove timestamp from date

Hi Experts, I have created a date calendar using DAX as below:   Date = GENERATE ( CALENDARAUTO(), VAR currentDay = [Date] VAR day = DAY( currentDay ) VAR month = MONTH ( currentDay ) VAR ye...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

HI Divya904

 

Maybe something like//

 

Date =
GENERATE (
CALENDARAUTO(),
VAR currentDay = [Date]
VAR dayShort = FORMAT(currentDay,"dd/MM/yyyy")
VAR day = DAY( currentDay )
VAR month = MONTH ( currentDay )
VAR year = YEAR ( currentDay )
RETURN ROW (
"day", day,
"short day" , dayShort,
"month", month,
"year", year )
)
  • Divya904's avatar
    Divya904
    Helper III
    8 years ago

    Hi Phil,

     

    Thanks for your reply.

    Tried the same DAX calculation that you have provided. But still getting the time stamp in the slicer. 

    Here is the screenshot from Desktop.

     

     

     

    Thanks and Regrads,

    Divya

    • Phil_Seamark's avatar
      Phil_Seamark
      Microsoft Employee
      8 years ago

      Hi Divya904

       

      It seems odd.  I tried to replicate it here and it works ok for me up in the web service.

       

      I've attached a simple example PBIX file that I used.  Can you upload that and see if it does the same thing?

       

       

      • Divya904's avatar
        Divya904
        Helper III
        8 years ago

        Hi Phil,

        Thanks for your prompt and sharing the .pbix file.

        In your Date slicer, there is time as well. Please let me know how can we remove this time, so that we have just dates in the dropdown.

        Thanks

         

        Regards,

        Divya