comparing 2 tables

[iksaum]

I have 2 tables:

Comment ID	Block #	Audited By	Broad	Theme	Sub-Theme	Problem	Location
2106576	1	KM
2702282	2	KM
13056960	1	KM	Product	Quality/Price
11120686	1	KM	Product	Size	Dimensions	Incorrect
11120686	2	KM	Product	Quality/Price
28670648	2	KM	Product	Quality/Price
28670648	4	KM
11078493	2	KM	Product	Material	Comfort
11078493	3	KM	Product	Color	Brightness/Tone	Incorrect	Image
17955280	1	KM	Logistics	Defect/Damage	Damage
17955280	4	KM
7517555	1	KM	Product	Size		Incorrect	Image
13630731	1	KM	Product	Size
13630731	4	KM	Product	Material	Texture
10866718	3	KM	Service	Communication			Phone
9039392	1	KM	Product	Quality/Price
21990409	1	KM	Logistics	Time
21990409	4	KM	Logistics	Defect/Damage
23544771	1	KM
13033413	3	KM	Product	Color	Didn't match decor
8367874	2	KM	Product	Assembly
5593860	1	KM
18612506	1	KM	Product	Quality/Price
18408073	3	KM	Service	Communication			Chat
13221775	1	KM	Product	Quality/Price	Stability/Flimsiness
13221775	2	KM
4964645	3	KM	Logistics	Carrier/DA	On-site behaviour
4964645	4	KM	Product	Material	Comfort
13543017	1	KM	Product	Color	Pattern
13543017	2	KM
4966303	2	KM	Product	Material	Construction Materials
4972892	3	KM	Product	Usability	Compatibility
8831673	1	KM	Product	Color		Incorrect
8862284	1	KM	Logistics	Carrier/DA
10227836	1	KM	Product	Material	Construction Materials	Missing (information/context)
21525724	2	KM	Logistics	Missing Parts
21525724	4	KM	Logistics	Defect/Damage	Defect
14879733	2	KM	Product	Color	Brightness/Tone	Incorrect	Image
11069342	2	KM	Logistics	Time
6270999	1	KM	Logistics	Missing Parts

and

Comment ID	Block #	Audited By	Broad	Theme	Sub-Theme	Problem	Location
2106576	1	KM	Product	Usability	Features
2702282	2	KM	Product	Usability	Features
13056960	1	KM	Product				Image
11120686	1	KM	Product	Size	Dimensions	Incorrect	Image
11120686	2	KM
28670648	2	KM	Logistics	Defect/Damage	Defect
28670648	4	KM	Product	Color
11078493	2	KM	Product	Assembly
11078493	3	KM	Product	Color			Image
17955280	1	KM	Logistics	Carrier/DA
17955280	4	KM	Service	Communication
7517555	1	KM	Product	Size			Description
13630731	1	KM	Product	Size	Dimensions
13630731	4	KM
10866718	3	KM
9039392	1	KM	Product	Material
21990409	1	KM	Logistics	Time	Delay
21990409	4	KM
23544771	1	KM	Logistics	Carrier/DA	Product handling
13033413	3	KM	Product	Color
8367874	2	KM
5593860	1	KM	Customer	Changed Mind/Error
18612506	1	KM	Product	Size	Capacity
18408073	3	KM
13221775	1	KM	Product	Quality/Price
13221775	2	KM	Product	Usability
4964645	3	KM	Service
4964645	4	KM	Product	Color	Didn't match decor
13543017	1	KM	Product				Image
13543017	2	KM	Logistics	Mis-Ship
4966303	2	KM
4972892	3	KM
8831673	1	KM	Product	Color
8862284	1	KM	Logistics	Mis-Ship
10227836	1	KM	Product				Description
21525724	2	KM	Product	Items Included			Image
21525724	4	KM
14879733	2	KM	Product	Color		Incorrect	Image
11069342	2	KM	Logistics
6270999	1	KM	Logistics

Is there any way that I can count the number of changes in these two tables in power bi??

please help!!

[v-piga-msft]

Hi @iksaum ,

I'm a little confused about your desired output. 

If it is convenient, could you describe your logic in details and your expected output so that we could give further advice?

Best  Regards,

Cherry

[iksaum]

@v-piga-msft 
The two tables shown above have the same column headers but some of the columns have different values. Is there any way as to which the number of changes can be calculated in these two tables??

[tex628 · Accepted solution]

To my knowledge there is no simple way to make that calculation. I have a solution that requires abit of work:

It looks like "Comment ID" and "Block #" can be combined to create a unique key. 

If this is the case you would create that key in both tables and then merge them together on that key. 
Include all columns from both tables. This should give you "Audited by" ... "Audited by.1" ... "Broad" ... "Broad.1" ... etc.

The next step is to create a custom column for each pair of columns:

Column = if [Audited by] = [Audited by.1] then 0 else 1

Create one for each pair of columns and then summarize the value of all these custom columns. Should give you the number of changed rows. 

/J

[tex628]

You want to count every change in every cell between the two tables? 

[iksaum]

@tex628 YES