Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Create customised matrix table based on another matrix table

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?

 
Show and Tell
Tutorial Requests

2 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    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

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

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

     

    Best Regards,

    Jay