Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.