Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sum Columns up (Quarterwise)

Hello all

 

In the picture below, i have 4 columns that display the 4 quarters of the year.

 

Now, i need Q2 to be the Sum of Q1 and Q2. Q3 = Q1+Q2+Q3 and same for Q4.

So Q4 would be 2'361'693.

Can i do that with a measure?

Any ideas?

 

Best regards 

Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    Anonymous

     

    Please change the formula to this one:

     

    Cumulative_Actual = 
CALCULATE (
        SUM ( Sheet1[Value] ),
        FILTER (
            ALLEXCEPT( Sheet1, Sheet1[frango]),
            Sheet1[Quarter] <= MAX ( Sheet1[Quarter] )
        )
    )

    Aslo you can see the formula in this workspace

10 Replies

  • themistoklis's avatar
    themistoklis
    Community Champion
    7 years ago

    Anonymous

     

    Can you try the following:

     

    Cumulative_Actual = 
CALCULATE (
    SUM ( Sheet1[Values] ),
    FILTER( ALL (Sheet1 ),
    Sheet1[Quarter] <= MAX( Sheet1[Quarter] ))
)

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      themistoklis

       

      Thanks for the quick response.

      I did not get it to work.

       

      I think further infos are needed.

      Matrix looks like:

       

      With the fields:

       

      Measure regarding your answer:

      Cumulative_Actual = 
CALCULATE (
    SUM(Alles[Media Net exkl. WZ]) + SUM(Alles[Posting Net]);
    FILTER(ALL (Alles[Quartal]);
    Alles[Quartal] <= MAX(Alles[Quartal]))
)

      "Alles" is the table. Its only one table with all the infos in there.

       

      I inserted tte result measure as column instead of "Quartal".

      What are my wrong thoughts?

      • themistoklis's avatar
        themistoklis
        Community Champion
        7 years ago

        Remove Quartal which is right after All.

         

        New formual attached:

         

        Cumulative_Actual = 
CALCULATE (
    SUM(Alles[Media Net exkl. WZ]) + SUM(Alles[Posting Net]);
    FILTER(ALL (Alles);
    Alles[Quartal] <= MAX(Alles[Quartal]))
)