cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## Comparison of two values in a matrix

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
1 ACCEPTED SOLUTION
Super User

you can merge tables in PQ

then create a column

flag = if(TableA[Type in Table A]=TableA[Type in Table B],0,1)

pls see the attachment below

Proud to be a Super User!

Super User

you can merge tables in PQ

then create a column

flag = if(TableA[Type in Table A]=TableA[Type in Table B],0,1)

pls see the attachment below

Proud to be a Super User!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.