Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I am wondering how to see if there is a row in one query that matches 3 or 4 columns in a different query. For example, I have a job query and an invoice query. I want to know if someone created an invoice for every job. So if a job row has a match on 3 columns in a row of the invoice query it will count it, but otherwise it will not count it. It would also need to ignore duplicates if two rows matched the original row
A simple example of the two tables:
Solved! Go to Solution.
@Anonymous - I would do the following:
1. Create a new Calculated Column on each table, which concatenates the 3 columns that need to be joined.
2. Create a Relationship between the two tables on this column.
3. Create a Measure like:
First Invoice = MIN('Invoice Query'[Invoice Number])
Hope this helps,
Nathan
@Anonymous ,
You may simply try CONTAINS to add a calculated column.
how woud you create the calculated column for each table? Please can you show me an example?
Thanks
@Anonymous - I would do the following:
1. Create a new Calculated Column on each table, which concatenates the 3 columns that need to be joined.
2. Create a Relationship between the two tables on this column.
3. Create a Measure like:
First Invoice = MIN('Invoice Query'[Invoice Number])
Hope this helps,
Nathan
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |