Forum Discussion
If statement using Custom Column
Hi Team im trying to get the logic of how i would make this work so that it can dispay everything not just the first command under Custom column, Please help if[AffiliateOwnerID]=2 and [Activ...
Hi again Anonymous ,
Let's see if I understood it now.
You start with something like this:
And want to end up with something like this:
If so, here is my proposal:
1. Create an Aux table like this one (named Target in my example):
2. Add a Custom Column to your main table with the following code:
Table.SelectRows(Target, (X)=> List.Contains({1,2},[ActivityTypeID]) and [AffiliateOwnerID] = 2)
3. Expand it: