Filter by last 20 hours power query

[mklevemann]

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.

[MasonMA · Accepted solution]

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:) 

[mklevemann]

Thanks!