Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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 iguais, quero que retorne "Ok"; caso contrário, quero que retorne "Nok".
resultado esperado:
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
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.
| User | Count |
|---|---|
| 15 | |
| 8 | |
| 6 | |
| 5 | |
| 5 |