locked
Accumulation in DAX RRS feed

  • Question

  • Hi

    I want to make an accumulation with DAX.

    I have this Schema:

    ..and I want this Balance result:

    Hope someone can put me in the right direction.

    Here is my workbook

    Thanks

    Tommy

    • Changed type LearningHorse Monday, March 23, 2015 4:22 PM Not a general discussion
    Monday, March 23, 2015 2:36 PM

Answers

  • I found a solution to the problem.

    I first calculated...

    Total Stock Balance

    = [Total Stock] + [Total Supply] - [Total Forecast]

    Then I calculated ...

    Accumulated Stock Balance

    =CALCULATE (

        [Total Stock Balance],

        FILTER (

            ALL ( Calendar[Month] ),

            Calendar[Month] >= 3

                && Calendar[Month] <= MAX ( Calendar[Month] )

        )

    )

    So I got this:

    The file is here.

    Tommy


    • Marked as answer by LearningHorse Tuesday, March 24, 2015 2:59 PM
    • Edited by LearningHorse Friday, April 3, 2015 6:33 AM Text edition
    Tuesday, March 24, 2015 10:00 AM