Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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?