Forum Discussion

edwardroa's avatar
edwardroa
Helper I
5 years ago
Solved

subtotal by multiple categories

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 be...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

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's avatar
    edwardroa
    Helper I
    5 years ago

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

     

     

    • edwardroa's avatar
      edwardroa
      Helper I
      5 years ago

      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's avatar
        edwardroa
        Helper I
        5 years ago

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