I have "clien's" table with client_id, and i have another table "invoices" where each invoice has client_id.
with power query I need to add in "client's" table column yes/no to check if every client are in "invoice" table.
wih the excel it would be simple lookup. how i can do it.
i tried with Table.Contains but did not suceeded.
Solved! Go to Solution.
For quick fixes, I merge queries on a common column and then write a custom column that replaces "null" with "no" and everything else with "Yes"
Merge "Clients" query and "Invoices" queries on Client-ID.
Expand any Client-ID column
CustomColumn = if [#"Client-ID"] is null then "No" else "Yes"
I implemented this between two tables with fewer than 30K rows each and got a pretty substantial performance hit when going to apply changes, FWIW.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.