Forum Discussion
Matrix replicating values for all users
Hi, I am trying to create a matrix using two tables: Accounts Quota: Account id User id Quota 1 1 10 2 2 20 Credit: Account id User id Credit 1 1 30 1 3 10 ...
Hey Greg_Deckler thanks for your help.
This did help me but I noticed another issue. If in credits table, the account exists but user doesn't exist then it is not showing the account altogether. For example,
accounts quota table:
| account | user | quota |
| 3 | 4 | 50 |
credit table:
| account id | user id | credit |
| 3 |
Then I am not seeing account 3 at all in my result matrix. Would you happen to know how I can fix that? I would still like to see:
| account id | user id | quota | credit |
| 3 | 4 | 50 |
rkaushik I recommend that you merge your 2 tables in Power Query like this:
let
Source = Table.NestedJoin(#"Accounts Quota", {"Account id"}, Credit, {"Account id"}, "Credit", JoinKind.LeftOuter),
#"Expanded Credit" = Table.ExpandTableColumn(Source, "Credit", {"Credit"}, {"Credit.Credit"})
in
#"Expanded Credit"