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]))
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Share the download link of the MS Excel file with your formulas/filters/Pivot/Comments Tables so that the logic can beunderstood and translated in the DAX formula language.