Forum Discussion

RAKESH1986's avatar
RAKESH1986
Helper II
3 years ago
Solved

Remove Time entry less than 5 am

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    
Need Help
  • KNP's avatar
    KNP
    3 years ago

    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.

     

KNP's avatar
KNP
Super User
3 years ago

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.