Forum Discussion

oadewuyi's avatar
oadewuyi
New Member
4 years ago
Solved

Find mismatch amount values in two two table

Hello all, I am working on a report that's basically dealing with comparison of values from an old legacy system with the new Mongo DB platform. There are about 11k records and the expected output i...
values
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please check the below picture and the attached pbix file.

    It is for creating a new table that shows unmateched IDs with values.

     

     

    New Table displays ID with unmatched values =
FILTER (
    Old,
    Old[Value1]
        - MAXX ( FILTER ( New, New[ID] = EARLIER ( Old[ID] ) ), New[Value1] ) <> 0
        && Old[Value2]
            - MAXX ( FILTER ( New, New[ID] = EARLIER ( Old[ID] ) ), New[Value2] ) <> 0
        && Old[Value3]
            - MAXX ( FILTER ( New, New[ID] = EARLIER ( Old[ID] ) ), New[Value3] ) <> 0
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new table that shows unmateched IDs with values.

 

 

New Table displays ID with unmatched values =
FILTER (
    Old,
    Old[Value1]
        - MAXX ( FILTER ( New, New[ID] = EARLIER ( Old[ID] ) ), New[Value1] ) <> 0
        && Old[Value2]
            - MAXX ( FILTER ( New, New[ID] = EARLIER ( Old[ID] ) ), New[Value2] ) <> 0
        && Old[Value3]
            - MAXX ( FILTER ( New, New[ID] = EARLIER ( Old[ID] ) ), New[Value3] ) <> 0
)