Name in Matrix

[Anonymous]

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

[Greg_Deckler]

Slicers?

Not sure I understand what you are going for here.

[Anonymous]

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

[v-lionel-msft]

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 Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

hello @v-lionel-msft,

I'll give you an excel with the example.

https://drive.google.com/open?id=1tvmd99UkkCGKt78Cx-RVa7pv8N4br_Lt

Thanks a lot

A greeting