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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
MaximeVall
Helper II
Helper II

Date of data update

Hello everybody, 

 

I want to have the date of the actual day, for that is good, but for the hour I would like that it is blocked at : 00:15. Because the data are update everyday at 00:15 am. 

 

Actually I have put this request : 

MaximeVall_0-1626343825620.png

and the result is : 

MaximeVall_1-1626344007309.png

 

And what I expect to have is :

15/07/2021   00:15:00

with the date which is updated and with the time fixed all the time. 

 

Can somebody could help me or now how to do it ?

 

Sincerly, a trainee...

1 ACCEPTED SOLUTION
mahoneypat
Employee
Employee

Please try this expression instead

 

= Date.From(DateTime.LocalNow()) & #time(0,15,0)

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

2 REPLIES 2
mahoneypat
Employee
Employee

Please try this expression instead

 

= Date.From(DateTime.LocalNow()) & #time(0,15,0)

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Thank you very much, it work good ! 

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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

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.