DAX grouping GL Accounts

[sureshsonti]

Hello,
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 Inventory $16,000

10300 A/R $18,000

10400 Prepaid $ 16,000

20000 A/P $100,000



I want to group GL accounts 10100, 10200, 10300, 10400 into Current Assets. Looking for a DAX statement.

Thanks for all your help

 

[GraH - Guido]

Alternative to a DAX measure, is adding a dimension table to group your GL accounts.

 

[sureshsonti]

Alternative to a DAX measure, is adding a dimension table to group your GL accounts.

Thanks Guido. Let me give it a try.