Change Measure Output to return only the date

[AW1976NOVA]

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?

[mh2587 · Accepted solution]

Admin Call Data Refresh Label ="Call Data Last Updated: " &FORMAT(( MAX ( 'Call_Data'[Refresh Date] ) ),"M/d/yyyy")
//Try This

[AW1976NOVA]

Perfect thank you!