Forum Discussion

naigen's avatar
naigen
Frequent Visitor
4 years ago

Remove Timestamps from Calendar Date - GetPivot on Excel

Hi all,

I'm currently building a model on excel that will allow me to reference a date column in a powerpivot using some excel formulas. 

the data is imported via powerquery and dax within excel.

so below is a example of data from the pivot table of the number im trying to bring in:

However when i try refrencing the table it has the below date format:

ideally what should be in the yellow column is: "01/03/2022"

When I look into the data model the date has a timestamp!

As you can see from the above this calender date includes a timestamp.

 

I'm not sure what I can do to get rid of the timestamp.

 

ideally I want to be able type a date into excel such as "01/03/2022" use the GET PIVOT function to refrence that date.

 

any help would be greately appreciated as I am unable to find anything on the web about this subject

 

 

Need Help

1 Reply

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, naigen ;

    Try it.

    1.Click the Home tab

    2.In the Number group, click on the drop-down

    3.Select Short date (or Long Date) – based on how you want the date to be displayed.

    https://trumpexcel.com/remove-time-from-date-in-excel/


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.