Forum Discussion

RAKESH1986's avatar
RAKESH1986
Icon for Helper II rankHelper 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.

     

1 Reply

  • KNP's avatar
    KNP
    Icon for Super User rankSuper 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.