Subract within a column applying multiple filters

[Anonymous]

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]

One way would be to use Data>Filter>Autofilter
Use the dropdown on the second column to select "blanks" and that will give
you the list of stores you are stillwaiting to hear from.

[Anonymous]

I'm sorry, it's dumb question time, I'm fairly new to Power BI, where do I find the options Data, Filter, Autofilter? Thanks for advice.

[amitchandak · Accepted solution]

@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))

[Anonymous]

Hi, it worked and I'm putting it into production. How can I develop this further to highlight additonal clients (for example) that are added to the table? Whilst totals work the details seem to fll over if new entrants did not xist in the table previously?