Forum Discussion
Helper IILastdate, how to remove the time?
Hi!
I am using the lastdate function to show the last date. However, both the date and the time is showing. Even though I have changed the format of the date colum to only show the date in my data. How can I remove the time?
Regards Marit
5 Replies
- amitchandak
Super User
Marit , It better to have a date column
Date = [Datetime].date
or try using .date in your calculation
Or try like
measure =
var _last = max(Date[Date].date)
return
calculate([Mes1], filter(Date =Date[Date].date =_last)) - Fowmy
Marit
You can format it to show only the date. Select the measure and choose a date format that has no time formatting.________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
