Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Last refreshed date instead of datetime format

Hi everyone, 

 

I have the query to generate last refreshed datetime below. However I would want to display in Date format ('dd/mm/yyyy') instead. Anyone has any idea how I can format this?

 

 

Regards,

BK

Need Help
Show and Tell
  • az38's avatar
    az38
    6 years ago

    Anonymous 

    sorry, also you can change Data type to Date in Power Query, of course. See in Transform ribbon

2 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous 

    you dont need any additional steps in Powe Query Editor - just go to the report mode, and set Data Type as Date

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous 

    sorry, also you can change Data type to Date in Power Query, of course. See in Transform ribbon