Forum Discussion
Change Measure Output to return only the date
Hi,
I have a created measure that is currently returing the MM/DD/YYYY HH:MM:SS. I want it to only return the Date in the format of MM/DD/YYYY and to drop the HH:MM:SS.
My measure =
Admin Call Data Refresh Label =
"Call Data Last Updated: " & ( MAX ( 'Call_Data'[Refresh Date] ) )
...where 'Call_Data'[Refresh Date] is already in the Power BI short date format.
In simple terms, how do I update the DAX of my created measure to return only the date?
Admin Call Data Refresh Label ="Call Data Last Updated: " &FORMAT(( MAX ( 'Call_Data'[Refresh Date] ) ),"M/d/yyyy")
//Try This
2 Replies
- mh2587
Super User
Admin Call Data Refresh Label ="Call Data Last Updated: " &FORMAT(( MAX ( 'Call_Data'[Refresh Date] ) ),"M/d/yyyy")
//Try This