Forum Discussion
Filter Data to show current date but with time condition
Hello everyone,
I have a set of data that shows transactions performed. The dataset shows data up to 7 days. I'm trying to achieve a workaround in Power Query where I would like to filter the data to show current date. However, it should come with a condition whereby the day starts at 0645am and ends on 0645am the following day (24 Hours). So technically, the data should show transactions performed on 17th August 2021 (Current day) which starts at 0645am and ends at 0645am the following day. I could only filter the data to show the current day but to enforce such condition, I'm unable to find the solution.
I have attached the excel file test in the link given. Thank you very much for your help and support!
You can use syntax like this in your filter step. Just create any datetime filter step on that column using the "Between" option, and then adapt the code to match the bold part.
= Table.SelectRows(#"Changed Type", each [Tasklist Signoff Date and Time] >= Date.AddDays(Date.From(DateTime.LocalNow()), -1) & #time(6,30,0) and [Tasklist Signoff Date and Time] <= Date.From(DateTime.LocalNow()) & #time(6,30,0))
Pat
1 Reply
You can use syntax like this in your filter step. Just create any datetime filter step on that column using the "Between" option, and then adapt the code to match the bold part.
= Table.SelectRows(#"Changed Type", each [Tasklist Signoff Date and Time] >= Date.AddDays(Date.From(DateTime.LocalNow()), -1) & #time(6,30,0) and [Tasklist Signoff Date and Time] <= Date.From(DateTime.LocalNow()) & #time(6,30,0))
Pat