Formulas - Somar, subtrair e comparar valores

[gus2701]

Necessito de uma função que compara os valores da seguinte forma:

Tabela xpot - Banco SQL
soma ofensores por demanda; coluna - ofensorqtddiasl;
soma por fase excluindo saldo / valor duplicado em cada fase; colunas - faseqtddias e etapa;
compara o saldo dos ofensores x fase (nenhum final os valores teriam que ser Zero);
Consigo fazer isso com DAX no Power BI ?

Obrigado,

Gustavo Santos

[gus2701 · Accepted solution]

Friends, Thanks for the help, but let's start by extracting the data. There are many errors that need correction. Goodbye .

[v-qiuyu-msft]

Hi @gus2701,

It seems that you want to achieve some requirement via DAX, right? 

Would you please clarify the requirement in English, so we can understand it better? 

Best Regards,
Qiuyun Yu 

[gus2701]

I need your help, to sum up values by removing the duplicate values.
There are two columns with values:
1-Time of each phases within the project. 2-Time worked on the project.
Values are duplicated within phases (per record line) because there are two or more people who have worked and consumed hours within the project.
The sum of the added values of each project and sum of time worked, compared must be equal. Subtracting from each other would be zero.

[v-qiuyu-msft]

Hi @gus2701,

Please share some sample data and show us the expected results so we can test it. 

Best Regards,
Qiuyun Yu