Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello friends,
Can you help me with how to write below formula properly please
I was thinking about is in ["ID 1","ID 2"] as we do in SQL queries.
Thank in advance.
Solved! Go to Solution.
Yes that's correct you can use a column from another table as the list for the 2nd argument
= if List.ContainsAny({[ID]} , Table2[ID]) then true else false
Regards
Phil
Proud to be a Super User!
Thank you @PhilipTreacy for your reply.
Is List.ContainsAny works with column as argument too?
Because what I really want is made the last argument of the function dynamic ie use the column of my dataset.
Below what I'm trying to do:
Yes that's correct you can use a column from another table as the list for the 2nd argument
= if List.ContainsAny({[ID]} , Table2[ID]) then true else false
Regards
Phil
Proud to be a Super User!
You can write this
= if List.ContainsAny({[ID]} , {1, 2, 3}) then true else false
regards
Phil
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
15 | |
13 | |
13 | |
13 | |
12 |