Forum Discussion

Murphs02's avatar
Murphs02
Frequent Visitor
3 years ago
Solved

Sumif for journal entry table

Hi  I am new to Power BI so bear with me! I am building. a report with sap data where I have multiple lines for journal numbers. I need to keep each line as I report on some information on line ite...
Need Help
  • Murphs02's avatar
    Murphs02
    3 years ago

    Hi , I got there eventually :-)with sum and Allexcept for the sumif filters.

     

    JOURNAL ENTRY TOTAL VALUE = CALCULATE(SUM('ACDOCA EXTRACT JE'[Amount in Global Currency - ABS /2]),ALLEXCEPT('ACDOCA EXTRACT JE','ACDOCA EXTRACT JE'[Journal Entry],'ACDOCA EXTRACT JE'[Fiscal Year],'ACDOCA EXTRACT JE'[Company Code]))
Murphs02's avatar
Murphs02
Frequent Visitor
3 years ago

Hi , I got there eventually :-)with sum and Allexcept for the sumif filters.

 

JOURNAL ENTRY TOTAL VALUE = CALCULATE(SUM('ACDOCA EXTRACT JE'[Amount in Global Currency - ABS /2]),ALLEXCEPT('ACDOCA EXTRACT JE','ACDOCA EXTRACT JE'[Journal Entry],'ACDOCA EXTRACT JE'[Fiscal Year],'ACDOCA EXTRACT JE'[Company Code]))