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 having trouble with the comaprison issue described below. I have 2 tables (A & B in the example) joined by the column called Group. The join is many in table A to one in table B. Both table A and table B have a "type." It is possible that the type from table A is not equal to the type from table B and when this happens I need to flag the record. In the example, item 4 from table A shows a type of corn, but it is joined to table B as a fruit and table B has a type of apple, not corn, so this should flag (and conditional format) in the resulting matrix. I would also like to flag it at the group level so that if the matrix is collapsed, the user can see that the data at the next level down is out of sync.
TableA: | ||
Item | Type | Group |
1 | Apple | Fruit |
2 | Apple | Fruit |
3 | Apple | Fruit |
4 | Corn | Fruit |
5 | Corn | Vegetable |
6 | Corn | Vegetable |
Table B: | |
Group | Type |
Fruit | Apple |
Vegetable | Corn |
Table A & B are joined on Group.
Report (matrix): | ||||
Group | Type (from Table A) | Type (from Table B) | Flag | |
Fruit | Apple | Apple | 1 | |
1 | Apple | Apple | 0 | |
2 | Apple | Apple | 0 | |
3 | Apple | Apple | 0 | |
4 | Corn | Apple | 1 | |
Vegetable | Corn | Corn | 0 | |
5 | Corn | Corn | 0 | |
6 | Corn | Corn | 0 |
Solved! Go to Solution.
you can merge tables in PQ
then create a column
Proud to be a Super User!
you can merge tables in PQ
then create a column
Proud to be a Super User!
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
90 | |
67 | |
62 | |
53 |