Forum Discussion
Map names to number hierarchy
Hi, hamtuv
You can try the following methods.
Column:
AccountName = CALCULATE(MAX('The Account map'[AccountName]),FILTER('The Account map',[Account]=EARLIER('Table'[Account])))AccountName1 = "1 Cash in"Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The table with the accounts
| Account | Value |
| 1002 | 10 |
| 1003 | 12 |
| 1004 | 10 |
The Account map
| Account | Name | AccountName |
| 1 | Cash in | 1 Cash in |
| 10 | Group 1 | 10 Group 1 |
| 100 | Group 2 | 100 Group 2 |
| 1002 | Group 3 | 1002 Group 3 |
| 1003 | Group 4 | 1002 Group 4 |
| 1004 | Group 5 | 1002 Group 5 |
I then want a matrix table that starts at 1, then you should be able to click the plus sign and it should drill down to 10, then 100 and so on.
Note it should be a matrix table with + signs that you can open more rows
| Account | Value |
| 1 Cash in | 32 |
| 10 Group 1 | 32 |
| 100 Group 2 | 32 |
| 1002 Group 3 | 10 |
| 1003 Group 4 | 12 |
| 1004 Group 5 | 10 |
Hi, hamtuv
Did you expect this kind of output?
The source data needs to be in this format.
Are you needing your the Account map table to morph to such data?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes but with the group names next to the account numbers, either in the same column or one next to the numbers, so in the example that you sent row 1 would be 1 Cash In, row 2 would be 10 Group 2 and so on.
Hi, hamtuv
You can try the following methods.
Column:
AccountName = CALCULATE(MAX('The Account map'[AccountName]),FILTER('The Account map',[Account]=EARLIER('Table'[Account])))AccountName1 = "1 Cash in"Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.