Calculate difference between two rows in visualisation table

[Anonymous]

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!

[Darren75]

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?

[Anonymous]

@amitchandak thank you!! 

[amitchandak · Accepted solution]

@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