Forum Discussion
Merge / Expand two calculated tables into one
Matti , Try a new table like
summarize(filter(Table, not(isblank(Table[ParrentKey]))), Table[AccTree],Table[ParrentKey])
I managed to solve my problem. Have a look at my solution below.
Turns out GenerateAll was the function I was looking for.
GENERATEALL (
CALCULATETABLE (SELECTCOLUMNS (Acc),"AccID, Acc[AccID],"AccTree", Acc[AccTree])),CALCULATETABLE(DISTINCT(Acc[ParrentAccKey]),FILTER(ALL(Acc),Acc[AccTree]=[AccTree] && NOT(ISBLANK(Acc[ParrentAccKey])))))
Super UserMatti , Try a new table like
summarize(filter(Table, not(isblank(Table[ParrentKey]))), Table[AccTree],Table[ParrentKey])
amitchandak you solved my initial question, thanks!
However, I did not word it quite right or provide a proper example. So let me try again.
So for each AccID, I need to add a row for each unique ParrentActKey within that account tree.
Example data provided below.
AccID AccTree ParrentAccID 1 1 1 2 1 3 1 4 1 4 5 1 6 1 7 1 8 2 8 9 2 10 2 10 11 2 12 3 12 13 3 14 3 15 3 Thank you!
I managed to solve my problem. Have a look at my solution below.
Turns out GenerateAll was the function I was looking for.
GENERATEALL (
CALCULATETABLE (SELECTCOLUMNS (Acc),"AccID, Acc[AccID],"AccTree", Acc[AccTree])),CALCULATETABLE(DISTINCT(Acc[ParrentAccKey]),FILTER(ALL(Acc),Acc[AccTree]=[AccTree] && NOT(ISBLANK(Acc[ParrentAccKey])))))