Forum Discussion

gus2701's avatar
gus2701
Frequent Visitor
8 years ago
Solved

Formulas - Somar, subtrair e comparar valores

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...
Reports
  • gus2701's avatar
    gus2701
    8 years ago

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

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

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's avatar
gus2701
Frequent Visitor
8 years ago

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's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi gus2701,

     

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

     

    Best Regards,
    Qiuyun Yu