Forum Discussion
Solved
Getting chart of accounts from column reference
Hi all. Hoping for som help with a problem i've run into. I have the below a chart of accounts that has been run through a function that splits the column _acc into respective numbers (using a functi...
I couldn't modify your query (as it points to a local file), but you can use the function in this article to get PATH functionality in PQ.
Guest Post: Using List.Accumulate for Input/Output Genealogy – The BIccountant
Pat
Hannisky I was wondering if you were trying to achieve the following outcome based on the following DAX concept:
PATH – DAX Guide
SQLBI Video
| AccountKey | ParentKey | Account Path | Path Length |
| 3051 | 111000 | 140000 | 120000 | 111000 | 3051 | 4 |
| 3052 | 111000 | 140000 | 120000 | 111000 | 3052 | 4 |
| 3053 | 111000 | 140000 | 120000 | 111000 | 3053 | 4 |
| 3054 | 111000 | 140000 | 120000 | 111000 | 3054 | 4 |
| 3055 | 111000 | 140000 | 120000 | 111000 | 3055 | 4 |
| 3056 | 111000 | 140000 | 120000 | 111000 | 3056 | 4 |
| 3057 | 111000 | 140000 | 120000 | 111000 | 3057 | 4 |
| 3058 | 111000 | 140000 | 120000 | 111000 | 3058 | 4 |
| 4051 | 130000 | 140000 | 130000 | 4051 | 3 |
| 4052 | 130000 | 140000 | 130000 | 4052 | 3 |
| 4053 | 130000 | 140000 | 130000 | 4053 | 3 |
| 4054 | 130000 | 140000 | 130000 | 4054 | 3 |
| 4055 | 130000 | 140000 | 130000 | 4055 | 3 |
| 111000 | 120000 | 140000 | 120000 | 111000 | 3 |
| 120000 | 140000 | 140000 | 120000 | 2 |
| 130000 | 140000 | 140000 | 130000 | 2 |
| 140000 | 140000 | 1 |
Hi no not really. Eg. 140000 should be expanded so that in column _ListAcc shows only accounts (4 digit numbers) for this we need to resolve that 120000 references 111000 and 112000 and not accounts.