Forum Discussion

Mike_Mace's avatar
Mike_Mace
Resolver I
6 years ago
Solved

Adding a column or a sum to a Running Column

I am using a running formula for a measure further below. I show running curves on graphs with dates on X axis. For one specific running measure I need to add the sum of a column in another table (o...
Need Help
  • Mike_Mace's avatar
    Mike_Mace
    6 years ago

    I was able to solve this by adding the columns on the same DAX calculating the running

     

    Running =
    CALCULATE(
        (SUM('Recovery'[Recovery]) + SUM('Actuals'[Actual])),
        FILTER(
            ALLSELECTED('Date Calendar'[Date Calendar]),
            'Date Calendar'[Date Calendar] <= MAX('Date Calendar'[Date Calendar])
        )
    )
Mike_Mace's avatar
Mike_Mace
Resolver I
6 years ago

I was able to solve this by adding the columns on the same DAX calculating the running

 

Running =
CALCULATE(
    (SUM('Recovery'[Recovery]) + SUM('Actuals'[Actual])),
    FILTER(
        ALLSELECTED('Date Calendar'[Date Calendar]),
        'Date Calendar'[Date Calendar] <= MAX('Date Calendar'[Date Calendar])
    )
)