Create customised matrix table based on another matrix table

[Anonymous]

Hi,

I have created a matrix table like this:

Now, I would like to use the values and apply a formula. Then, visualize this in another matrix table with the same column name and row name. For example (first row, first two dates) : (36*100/323) - 100  = -88.9 % and so on...

My question is, how can I use the value from the table and apply the formula. Then display the result in another table?

[Anonymous]

Hi @Anonymous ,

Did the last reply solve your problem? Please consider mark the answer as solution if it works.

Best Regards,

Jay

[mwegener]

Hi @Anonymous ,

You have to write the formula as a DAX measure. Something like that...

MyCalc =
VAR _DAY =
    SUM ( Table[Value] )
VAR _PREV_DAY =
    CALCULATE ( SUM ( Table[Value] ), DATEADD ( 'Date'[Date], -1, DAY ) )
RETURN
    DIVIDE ( _DAY * 100, _PREV_DAY ) - 100