Need help summing values of one column from unique values in two other columns

[kblommer]

I have some data that I am trying to sum up based on unique values from two other columns. There are three columns: Year, Class, and Usage. I am trying to have it filter through the Year and Class columns and for each unique combination of those columns, it will sum up the Usage column. I have about 100,000 rows of data so is there a function I can use where I don't have to explicitly write in the column combination and it will just sum up the distinct combinations by itself?

Thanks!

[Geradav]

Hi @kblommer 

Is the following what you are trying to achieve?

Then a simple SUM ( Table[Usage] ) should do. Unless I misunderstood something?

Let us know if that's not what you are looking for

[Mariusz]

Hi @kblommer 

Can you provide a data sample?

Best Regards,
Mariusz

Please feel free to connect with me.

[kblommer]

Thanks!

[Mariusz]

Hi @kblommer ,

Are you looking to output a table an extra column to this table or a measure?

Best Regards,
Mariusz

Please feel free to connect with me.

[kblommer]

I am trying to output a table for instance that looks like this:

Thank you for your help!

[Mariusz · Accepted solution]

Hi @kblommer 

You can do it in Query Editor.

Select Class column, go to Transform Ribbon and click Pivot Column and for Values Column select Usage.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.