Forum Discussion
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...
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.
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.