Forum Discussion
Subract within a column applying multiple filters
Hi, I have a dataset that takes a daily snapshot of clients with measures; client count, weeks and hours. For any two given dates I want to be able to calculate the variance (most recent minus oldest) in the measures, i.e. change in count, hours and weeks. I want to be able to filter on client name, manager and segment. Have tried indexing and using EARLIER. Guidance would be greatly appreciated.
The variance between 4th and 5th would show Change in Clients 1, Change in Hours 150 and Change in Weeks 2.
Anonymous
Assuming you are using a date table selected two dates in slicer then you can have like
Measure =
var _min = minx('Date','Date'[Date])
var _max = maxx('Date','Date'[Date])
return
calculate(sum(Table[Hours]),filter('Date','Date'[Date]=_min))- calculate(Table[Value],filter('Date','Date'[Date]=_max))
4 Replies
- amitchandak
Super User
Anonymous
Assuming you are using a date table selected two dates in slicer then you can have like
Measure =
var _min = minx('Date','Date'[Date])
var _max = maxx('Date','Date'[Date])
return
calculate(sum(Table[Hours]),filter('Date','Date'[Date]=_min))- calculate(Table[Value],filter('Date','Date'[Date]=_max))