Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Marit
Helper II
Helper II

Lastdate, 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

1 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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

5 REPLIES 5
Fowmy
Super User
Super User

@Marit 

You can format it to show only the date. Select the measure and choose a date format that has no time formatting.

Fowmy_0-1599114102174.png

________________________

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

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

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

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

That worked fine, thank you a lot!

amitchandak
Super User
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))

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.