Forum Discussion

Iguinrj's avatar
Iguinrj
Helper I
3 years ago

DAX/Logic Function - Parameter Beatin

Gostaria de saber como posso realizar a seguinte comparação utilizando a linguagem DAX. Preciso comparar a versão de um atributo do mesmo parâmetro em tabelas diferentes. Se os valores forem igu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Iguinrj ,

 

First consider appending three tables as one:

UnionTable = UNION('Table2','Table3','Table4')

Then create a new calculated column in Table1:

Column5 = 
IF(
    COUNTROWS(
        FILTER(
            'UnionTable',
            'UnionTable'[Column1] = 'Table1'[Column1] &&
            'UnionTable'[Column2] = 'Table1'[Column2] &&
            'UnionTable'[Column3] = 'Table1'[Column3] &&
            'UnionTable'[Column4] = 'Table1'[Column4]
        )
    ) > 0,
    "equals",
    "different"
)

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

  • Iguinrj's avatar
    Iguinrj
    Helper I
    3 years ago

    I need to do the following comparison:

    Example: if the values ​​of the same attribute of the same element from different tables are equal. If they are equal, I need to return: equal requirements; if they are different, different parameters.