Forum Discussion

ghostonpower225's avatar
ghostonpower225
Frequent Visitor
4 years ago

Delete Row after condition is met

I am trying to delete status "P" row once there is a date in due date actual for status "I". I can not seem to wrap my head around this one. Any support or help is much needed.   Status I...
General Comment
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
4 years ago

post your advanced editor code here and i'll have a look

  • ghostonpower225's avatar
    ghostonpower225
    Frequent Visitor
    4 years ago

    let
    Source = Blank,
    #"Removed Duplicates" = Table.Distinct(Source, {"041_circuit_layout_order_base_nbr"}),
    #"Added Custom" = Table.AddColumn(#"Removed Duplicates", "DTAndI", each if [CLO_Status] = "I" and [Due_Date_Actual] <> null then 1 else 0),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Custom.1", each let AnID = [Combined_CLLI] in if [CLO_Status] = "P" then Table.MatchesAnyRows(#"Added Custom",each [Combined_CLLI] = AnID and [DTAndI] = 1) else null)
    in
    #"Added Custom1"