Forum Discussion
Filter by last 20 hours power query
I am trying to filter some records that have a date/time field but I only want the ones that have occurred in the last 20 hours. Any idea on how I can filter that in power query? Thanks.
Hello mklevemann
Assuming your table has Timestamp or Date/time column that looks like below
Click 'fx' to 'Add Step', and use below M code (but remember to replace ' Source ' to the name of your previous step, my last step in below picture is ' #"Changed Type" ' and [EventTimestamp] to your actual date/time Column)
= Table.SelectRows(Source, each [EventTimestamp] >= DateTime.LocalNow() - #duration(0, 20, 0, 0))Hope this helps:)
2 Replies
- MasonMA
Super User
Hello mklevemann
Assuming your table has Timestamp or Date/time column that looks like below
Click 'fx' to 'Add Step', and use below M code (but remember to replace ' Source ' to the name of your previous step, my last step in below picture is ' #"Changed Type" ' and [EventTimestamp] to your actual date/time Column)
= Table.SelectRows(Source, each [EventTimestamp] >= DateTime.LocalNow() - #duration(0, 20, 0, 0))Hope this helps:)
Thanks!
