Table cell calculation from existing matrix values

[elyamiel1976]

Hi,

I have a matrix holding values for Actives per period :

I would like to show on a separate table ( a single cee actually) the ratio between current month and last month.

So for example it wulld show 109% for this data.

I couldnt find any way to create a table that will hold values based on calculation from cells on the same column.

will appritiane any ideas.

Thanks

Ely

[v-eachen-msft · Accepted solution]

Hi @elyamiel1976 ,

You don't have to create a table, you could get the value with a measure.

Measure =
DIVIDE (
    LOOKUPVALUE ( test[active], test[period], "2_current_month" ),
    LOOKUPVALUE ( test[active], test[period], "3_last_month" )
)

If you only want a table, you could use the following DAX to create a new table.

Table 2 =
ROW (
    "percentage", DIVIDE (
        LOOKUPVALUE ( test[active], test[period], "2_current_month" ),
        LOOKUPVALUE ( test[active], test[period], "3_last_month" )
    )
)

Then change the format type to percentage format.