Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I have a problem in Power BI that I can’t seem to resolve and maybe one of you can.
I am attempting to find the difference between two columns in a matrix table. The columns are based on a slicer (snapshot date). I want this to be dynamic so that if the user selects two different snapshot dates in the slicer, the matrix table will show the difference between these newly selected dates. So to summarize:
Delta measure showing the difference between two selected snapshot dates.
Any ideas?
Thanks
Solved! Go to Solution.
@amitchandak , Thanks for your reply.
I tried your solution and I didn't quite work the way I intended. I found another post which worked for me which can be found here: https://community.powerbi.com/t5/Desktop/Difference-between-two-columns-or-rows/td-p/188185
Thanks again.
@Tom216 , A measure like this should help
Measure =
var _max = maxx(allselected('Date'),'Date'[Date])
var _min = minx(allselected('Date'),'Date'[Date])
return
calculate(sum(table[tons]),filter(All(DATE), Date[Date] =_max)) - calculate(sum(table[tons]),filter(All(DATE), Date[Date] =_min))
Measure =
var _max = maxx(allselected('Date'),'Date'[Date])
var _min = minx(allselected('Date'),'Date'[Date])
return
calculate(sum(table[tons]),filter(Allselected(DATE), Date[Date] =_max)) - calculate(sum(table[tons]),filter(Allselected(DATE), Date[Date] =_min))
There is nothing column or row diff. You need to have diff measures
@amitchandak , Thanks for your reply.
I tried your solution and I didn't quite work the way I intended. I found another post which worked for me which can be found here: https://community.powerbi.com/t5/Desktop/Difference-between-two-columns-or-rows/td-p/188185
Thanks again.
User | Count |
---|---|
141 | |
70 | |
70 | |
53 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
60 | |
57 |