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...
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" )
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper 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" )