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 chan...
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
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?