Forum Discussion
Marit
Helper II
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 dat...
amitchandak
Super User
Super UserMarit , 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))