Forum Discussion
Solved
CLOCK Table Filtering
Greetings. I've got a growing appointments table (950k+, since 2023, well over 2 milllion if I up to 2021), for which I need numerous flags that depend on the appointment time. In order to reduce...
I figured it out. Turns out that the date_time had miliseconds precision. But because extracted the data as datetime, the format within PBI gave no clue about it. And the decimals remained even after "splitting" the time value.
Whereas my Clock_Table had "integer values behind" each time value.
I solved i with
cast (date_time as datetime2(0))Thanks for your input.
Hi JavierLopezFALP,
Thank you for sharing your insights and approach in resolving the issue.
We kindly request you to mark your response as the accepted solution, as this will help other community members find answers to similar challenges more efficiently.
Please continue leveraging the Fabric Community for any further assistance with your queries.
Thank you.