Forum Discussion
Name in Matrix
Buenos dias,
I have a matrix like the one attached to the image with accounting movements broken down by levels.
In the example
Level 1 240900
Level 2 24090000
And a table with all the ledger accounts, in which for each account I have its breakdown, then in power bi with the pathitem I create columns with those breakdowns. The table is attached in the image.
In the matrix in the rows I'm grouping by the fields Level Account1, AccountLevel2, ...
and in values I'm putting the CanName field, but this field information shows me erroneously.
There is some way with DAX that for example I can go to my chart of accounts and look for account '240900' and company '1'
That is to get for each row the value that is displayed in the left column and query it in my accounts table to display it in the descriptions column.
Thanks a lot
A greeting
4 Replies
Slicers?
Not sure I understand what you are going for here.
Hello
In the Ledger account column what I want to name the accounts that come out in the first column.
The problem is that in the first column the accounts come out of different fields.
In the Dim accounts table I have this:
accountMovition description Accountivel1 Cuentaivel2 Cuentaivel3
47000501 Expenses 4 470005 47000501
In the matrix you see this, broken down by the levels.
Account Description
+ 4 desc, incorrect --> I'm trying to get this description, I have it in the accounts table in another record
+ 470005 desc, incorrect
+ 47000501 Expenses
Thanks a lot
A greeting
Hi Anonymous ,
Please give us a example data and a example matrix you want to get, you can do it in excel.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
