Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Filter Function with "Not Contains"

Hi All, Any help would be appreciated I already have a formula in place , I just want to add third condition to this: First Condition : - if status =1 Second Condition : - Total time for same A v...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ahmedoye ,

 

You should first add column in power query like below, and then modify your formula like below:

FilteredTable = 
SELECTCOLUMNS(
    FILTER(
        Table1,
        [status] = 1 &&  
        [First Characters] > 5 && 
        NOT(
            CONTAINSSTRING([C], "ACL") || 
            CONTAINSSTRING([C], "BCL") 
        )
    ),
    "A", [A],
    "B", [B],
    "C", [C],
    "Status", [status],
    "Duration", [Time]
)

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous thanks for replying. Please see my result table. all rows where colum A = 1001, NONE of column C values contain "ACL" or "BCL". Therefore, all of A= 1001 is included. But for A = 1002, there is at least ONE value in C that contains "ACL". Therefore, all of rows where A = 1002 are excluded.
I need a condition where it considers above scenario.