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...
Show and Tell
Tutorial Requests
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