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 ...
Need Help
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    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's avatar
    Ritaf1983
    3 years ago

    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.

     
DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

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
    3 years ago

    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's avatar
      ADSL
      Icon for Post Prodigy rankPost Prodigy
      3 years ago

      Hi DOLEARY85 ,

       

      Thank you for your helpful feedback.

       

      Best Regards,