Forum Discussion

bbajuscak's avatar
bbajuscak
Helper I
1 year ago
Solved

Display Differences Between 2 Matrices

I have 2 seperate matrices, each built from different data sources, using different tables and table structures. Tables making up each matrix are not related to one another. Each matrix is a heirarc...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    You will want to clean this up as it will have a massive impact on performance.

     

    Here is the general approach for the comparison

     

     

    DEFINE
	VAR a = SELECTCOLUMNS(SUMMARIZECOLUMNS(
							'KI - Epics'[Initiative Name],
							'KI - Epics'[Project Name],
							'KI - Story'[Key + Status],
							'KI - Epics'[Key + Status]),
			"Column1", 'KI - Epics'[Initiative Name],
			"Column2", 'KI - Epics'[Project Name],
			"Column3", 'KI - Story'[Key + Status],
			"Column4", 'KI - Epics'[Key + Status])
	VAR b = SELECTCOLUMNS(SUMMARIZECOLUMNS(
							'Initiatives - Issues'[SUMMARY],
							'Project - Issues'[SUMMARY],
							'Epics - Issues'[Key + Status],
							'Stories - Issues'[Key + Status]),
			"Column1", 'Initiatives - Issues'[SUMMARY],
			"Column2", 'Project - Issues'[SUMMARY],
			"Column3", 'Epics - Issues'[Key + Status],
			"Column4", 'Stories - Issues'[Key + Status])
EVALUATE
	EXCEPT(a,b)

     

AllisonKennedy's avatar
AllisonKennedy
Community Champion
1 year ago

bbajuscak  The only way to highlight differences is to have the data related in some way. One option is to use Power Query and do a merge - you could do a 'left outer' merge to find only things that are in the first table and not in the second table.