Forum Discussion

KuntalSingh's avatar
KuntalSingh
Helper 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
Super 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
Helper 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