Forum Discussion

Rinat's avatar
Rinat
Icon for Helper I rankHelper I
4 years ago

Append multiple columns with filter enabled

Hello everyone. I'm trying to append multiple columns into 1 column without duplicates. I was able to write this to achieve that:   People sys_id = DISTINCT( UNION( VALUES(sn_control[owner]),...
Need Help
Rinat's avatar
Rinat
Icon for Helper I rankHelper I
4 years ago

yes. Tables are related. I want to filter by values in sn_profile[dv_u_regulatory_flag]. It can contain Value1, Value2 or Value1,Value2. Thank you for your help. 

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Rinat 

 

You need to write the logic of your filter into the formula. 

Try this:

People sys_id =
DISTINCT (
    FILTER (
        UNION (
            VALUES ( sn_control[owner] ),
            VALUES ( sn_control[u_control_performer] ),
            VALUES ( sn_control[u_evidence_collector] ),
            VALUES ( sn_control[u_control_executive] )
        ),
        RELATED ( sn_profile[dv_u_regulatory_flag] ) IN { value1, value2 }
    )
)

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

 

Best Regards,

Community Support Team _Janey