Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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?

 

last refreshed datetime.png

 

Regards,

BK

1 ACCEPTED SOLUTION
az38
Community Champion
Community Champion

@Anonymous 

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


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

2 REPLIES 2
az38
Community Champion
Community Champion

@Anonymous 

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


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
az38
Community Champion
Community Champion

Hi @Anonymous 

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


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.