Forum Discussion

Regular Visitor

2 years ago

Create a table/matrix where rows and colums are the same field and the values are the difference

Hi, I am trying to show the difference of the VALUE column month by month. I explain: This is my dataset. I have two columns, one is the column "value_date" in format dd/mm/yyyy and the other...

Need Help

Tips and Tricks

ERD

Community Champion

2 years ago

Tasnalem , not sure this is what you need, but you can try this approach:

1. Create a second Date table.

2. Use both in Matrix visual.

3. Create a measure:

test = 
var m_1 = SELECTEDVALUE('Date'[YYYYMM])
var m_2 = SELECTEDVALUE(Date_2[YYYYMM])
var x1 = CALCULATE(SUM(Data[Value]), REMOVEFILTERS('Date_2') )
var x2 = CALCULATE(SUM(Data[Value]), REMOVEFILTERS('Date') )
return 
x1-x2

Data: