cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## 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

1 ACCEPTED SOLUTION
Community Champion

@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 10
Community Champion

@Anonymous

Can you try the following:

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

Anonymous
Not applicable

@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:

```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?

Community Champion

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]))
)```

Anonymous
Not applicable

Its missing the "Frango" Column, it should be considered somehow.

The result i get now is the total of all frangos.

And also, i need 4 columns, not 1 that is the total.

Community Champion

@Anonymous

Have you put frango as rows, Quarters as Columns and values will be the new measure?

On a matrix and not on a single table

Anonymous
Not applicable

Yes i do.

Expected for first frango:

Community Champion
Is it possible to share the work space?
Anonymous
Not applicable

Not really...

But i will try to create a file with dummy data for you.

Anonymous
Not applicable
Community Champion

@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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors