Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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 🙂
⭕ 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
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
That worked fine, thank you a lot!
@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))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |