Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!
Solved! Go to 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
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
@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??
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
You want to count every change in every cell between the two tables?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |