Forum Discussion

Mike_Mace's avatar
Mike_Mace
Icon for Resolver I rankResolver 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
Icon for Resolver I rankResolver I
6 years ago

Hi v-eachen-msft ,

 

Yes running DAX works thanks for confirming. So now I have two running columns on that DAX.

I need a third column which adds the two columns per row.  That would make14th of Feb sum 6 and 19th of March 15 on table below.

This is where i tried SUMX but couldn't get anywhere.

 

 
Mike_Mace's avatar
Mike_Mace
Icon for Resolver I rankResolver I
6 years ago

  • Mike_Mace's avatar
    Mike_Mace
    Icon for Resolver I rankResolver 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])
        )
    )