Applied & Get the data refresh date in Power BI

[ADSL]

Hi BI Community Team,

We are getting full lenght of date/time as the screenshot below with measure:

Refresh Date = MAX(DAILY_TIME[CALL_DATE])

Any suggestion if we want to get the format below?

>> 26 Mar 2023

[DOLEARY85 · Accepted solution]

Hi,

if you click on the measure field in the data pane, go to the measure tools ribbon and select the format you want for the field

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Ritaf1983 · Accepted solution]

Hi @ADSL 

Nest your function with format according to your desired pattern.
Attached is an image for your reference

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ADSL]

Hi @Ritaf1983 ,

Thank you very much!

Best Regards,

[DOLEARY85 · Accepted solution]

Hi,

if you click on the measure field in the data pane, go to the measure tools ribbon and select the format you want for the field

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[DOLEARY85]

On checking that particular format wasn't there - you can just type the format into the format field:

dd mmm yyyy

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[ADSL]

Hi @DOLEARY85 ,

Thank you for your helpful feedback.

Best Regards,