Forum Discussion
Calculate difference between two rows in visualisation table
Hi there,
Is there any way to calculate the percentage differences for all columns between the two rows in the visualisation table? The two rows are selected based on filtered dates that may change. Thank you!
Anonymous , You can do it basis rows, you can based on two selected dates
example
Meausre =
var _min =minx(allselected('Date'), 'Date'[Date])
var _max maxx(allselected('Date'), 'Date'[Date])
return
CALCULATE(sum('Table'[Qty]), FILTER(('Date'),eomonth('Date'[Date],0) = _max)) - CALCULATE(sum('Table'[Qty]), FILTER(('Date'),eomonth('Date'[Date],0) =_min))or
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9
7
3 Replies
Anonymous , You can do it basis rows, you can based on two selected dates
example
Meausre =
var _min =minx(allselected('Date'), 'Date'[Date])
var _max maxx(allselected('Date'), 'Date'[Date])
return
CALCULATE(sum('Table'[Qty]), FILTER(('Date'),eomonth('Date'[Date],0) = _max)) - CALCULATE(sum('Table'[Qty]), FILTER(('Date'),eomonth('Date'[Date],0) =_min))or
Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9
7amitchandak thank you!!
I also have a similar issue to the subsriber above I want to calculate the variance % between all the columns in the 2 rows, in the following visualisation table, any suggestions?
