Forum Discussion

sureshsonti's avatar
sureshsonti
Icon for Helper II rankHelper II
7 years ago
Solved

DAX Sumif or Grouping GL

I am using power pivot dax I have a few GL accounts that I want to group under one measure or column. Example I have    GL           Desc          Amt 10100    Checking    $ 15,000 10200    Inv...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    Create a 2 column Table with GL codes in the first column and Groupings in the second one.  Create a relatiosnhip from the GL column of your base data to the GL codes column of the second table.  In your visual, drag GL codes and Groupings from the second table.

     

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

 

Create a 2 column Table with GL codes in the first column and Groupings in the second one.  Create a relatiosnhip from the GL column of your base data to the GL codes column of the second table.  In your visual, drag GL codes and Groupings from the second table.

 

Hope this helps.