Forum Discussion

KuntalSingh's avatar
KuntalSingh
Icon for Helper V rankHelper V
2 years ago
Solved

Need help on filtering data based on conditions

Hi Team I want to filter mention below sample data based on conditions Conditions are  In column Basic_cost_total only Blank and 0 values Coulumn Freight_total, Insurance_total and Insp_Total eit...
Need Help
  • slorin's avatar
    slorin
    2 years ago

    Hi

     

    = Table.SelectRows(Source, each 
        ([Basic_cost_total] = 0 or [Basic_cost_total] = null) 
         and
        ([Freight_total]<>null or [Insurance_total]<>null or [Insp_Total]<>null)
      )

     

    Stéphane 

slorin's avatar
slorin
Icon for Super User rankSuper User
2 years ago

Hi

 

= Table.SelectRows(Source, each 
    ([Basic_cost_total] = 0 or [Basic_cost_total] = null) 
     and
    ([Freight_total]<>null or [Insurance_total]<>null or [Insp_Total]<>null)
  )

 

Stéphane 

  • KuntalSingh's avatar
    KuntalSingh
    Icon for Helper V rankHelper V
    2 years ago

    Thanks for your reply

    There is a bit change 

    Instead of Freight_Total, Insurance_Total and Insp_Total

    Need : 

    In column Basic_cost_total only Blank and 0 values

    Coulumn Freight_MIGO ,Freight MIRO, Insurance_MIGO ,Insurance_MIRO  and Insp_MIGO  Insp_MIRO either one of them have some value except 0 and null