Forum Discussion

ADSL's avatar
ADSL
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

Applied & Get the data refresh date in Power BI

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

 

 

 

 

  • 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 👍


  • 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.

     

5 Replies

  • DOLEARY85's avatar
    DOLEARY85
    Icon for Resident Rockstar rankResident Rockstar

    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's avatar
      DOLEARY85
      Icon for Resident Rockstar rankResident Rockstar

      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 👍

  • 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.