Solved: Remove Time entry less than 5 am

RAKESH1986 · ‎03-13-2023

Hi,

Could you help me how I can remove the row entry which is less than 5 am...or between 12 am to 5 am?

for any particular date, I want to remove these entries.

thanks

KNP · ‎03-13-2023

If you actually want to remove the rows, just filter them out...

If you want to replace them, the easiest way is to add a new conditional column...

= Table.AddColumn(#"Changed Type", "Custom", each if [Access_Time] >= #time(0,0,0) and [Access_Time] < #time(5,0,0) then null else [Access_Time])

Then delete the old and rename the new if necessary.

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.

Proud to be a Super User!

View solution in original post