Lastdate, how to remove the time?

[Marit]

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

[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 🙂

YouTube  LinkedIn

________________________

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 🙂

YouTube  LinkedIn

[Marit]

I have allready done this, but the time is still showing.

[Fowmy · Accepted solution]

@Marit

It should work as long as the column is formatted as a date column. Can you share the measurement?

You can test your : FORMAT([Your measure],"dd/mmm/yyyy")

Thank you

Fowmy

[Marit]

That worked fine, thank you a lot!

[amitchandak]

@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))