subtotal by multiple categories

[edwardroa]

Hi all,

Have searched through multiple threads but unable to find the solution. 

I'm needing a simple subtotal by 2 categories in the form of a calculated column. As an example, I need the below highlighted result please:

Thanks in advance, I'm sure it's quite easy but think my brain is fried trying to find the correct solution.

Kind regards,

Ed

[Ashish_Mathur · Accepted solution]

Hi,

Try this calculated column formula

=calculate(sum(data[liability]),filter(data,data[asset type]=earlier(data[asset type])&&data[year buckets]=earlier(data[year buckets])))

Hope this helps.

[edwardroa]

Thanks Ashish,
When I get to the "EARLIER" function it doesn't allow me to select the Asset Type or Year Buckets columns?

[edwardroa]

Hi Ashish,

I get to the below part of the formula however when I start to type Asset Type, it doesn't bring up Asset Type as a column to select from?

[edwardroa]

My mistake Ashish,
I missed a bracket in your dax formula. It is working now, thank you very much!

[Ashish_Mathur]

You are welcome.