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