Forum Discussion

Justin_Dybedahl's avatar
Justin_Dybedahl
New Member
2 years ago
Solved

Comparing two values between tables

I'm writing a report on M365 data and I'm trying to create a column in a table visual that shows if the version of M365 is supported by Microsoft.  My issue here is that I'm trying to compare the two values in table 2 (device inventory) against table 1 (supported versions) and return a new column (Yes/No) in table 2 stating if the version of M365 is supported.  I've been banging my head against this for a while.  Thank you in advance.

 

Table 1:

ChannelBuild Version
Current17029
Semi-Annual15601
Semi-Annual16130

 

Table 2:

Device NameUsernameBuild VersionChannel
Joe_PCJoe16130Semi-Annual
Don_PCDon15601Semi-Annual
Sarah_PCSarah17029

Current

 

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file whether it suits your requirement.

     

     

     

    expected result CC =
VAR _condition =
    CALCULATE (
        COUNTROWS ( 'supported versions' ),
        TREATAS (
            SUMMARIZE (
                FILTER (
                    'device inventory',
                    'device inventory'[Device Name] = EARLIER ( 'device inventory'[Device Name] )
                        && 'device inventory'[Username] = EARLIER ( 'device inventory'[Username] )
                ),
                'device inventory'[Build Version],
                'device inventory'[Channel]
            ),
            'supported versions'[Build Version],
            'supported versions'[Channel]
        )
    ) >= 1
RETURN
    IF ( _condition, "Yes", "No" )

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    2 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file whether it suits your requirement.

     

     

     

    expected result CC =
VAR _condition =
    CALCULATE (
        COUNTROWS ( 'supported versions' ),
        TREATAS (
            SUMMARIZE (
                FILTER (
                    'device inventory',
                    'device inventory'[Device Name] = EARLIER ( 'device inventory'[Device Name] )
                        && 'device inventory'[Username] = EARLIER ( 'device inventory'[Username] )
                ),
                'device inventory'[Build Version],
                'device inventory'[Channel]
            ),
            'supported versions'[Build Version],
            'supported versions'[Channel]
        )
    ) >= 1
RETURN
    IF ( _condition, "Yes", "No" )