sureshsonti
Member
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
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