Im trying to make a Slice on Table 1. This Slice has 3 columns
[Code No.], [Status] and [Remarks].
This formula works perfectly
=ifs([Status] =“Available”, [Status] =“Reserved”])
What I want is, I want to add a condition based on another Table Slice. This second slice has 2 columns onlys. The slice name is “Reference”
[Code No.] and [Status]
I want to insert this formula in Slice 1 filter condition
Not(In([ Code no.], Reference[Code No.]))
Im trying to combine using OR but i cannot figure it out . Any suggestion?