Forum Discussion
Solved
Substract column - measure
Hi Guys, I have 42 weeks with data in the matrix table. When choosing from the filter (2 weeks), I would like to be able to subtract the values from each other. But I would like to be able to subt...
Arti12 , A measure like
sales =
var _max = maxx(allselected('Date'),'Date'[Week])
var _min = minx(allselected('Date'),'Date'[Week])return
calculate([Measure], filter('Date', 'Date'[Week] =_max)) - calculate([Measure], filter('Date', 'Date'[Week] =_min))or
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Anyone? 🙂