Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |