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.
Hi everyone,
I have this table in Power Query and I want to check if the value in column ID is available in the column PARENT ID.
For example, the ID 12 is available in PARENT ID column so we can create a new column and put "AVAILABLE" and for the ID 6 put "NOT AVAILABLE".
I want to do it in Power Query and not in Power BI because I need to import only the AVAILABLE values.
Thanks in advance for your support !
Solved! Go to Solution.
=Table.AddColumn(YourTableName,"Custom",each if List.Contains(YourTableName[PARENT ID],[ID]) then "AVAILABLE" else null)
=Table.AddColumn(YourTableName,"Custom",each if List.Contains(YourTableName[PARENT ID],[ID]) then "AVAILABLE" else null)
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 |