Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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.
Thanks Ashish,
When I get to the "EARLIER" function it doesn't allow me to select the Asset Type or Year Buckets columns?
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?
My mistake Ashish,
I missed a bracket in your dax formula. It is working now, thank you very much!
You are welcome.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |