Net usage

[Anonymous]

I have a data slicer in my report and I want to create a measure that will subtract the value at end of the date filter from the value at the start data selected

for example if i set my date slicer to between 4-20 - 4-24 I want the value to show 40 (120-80)

Date    Value

4-20     120

4-21      110

4-22      100

4-23       90

4-24       80

Thank you!

[camargos88 · Accepted solution]

hI @Anonymous ,

Try this measure:

Measure =

VAR _min = MINX(VALUES('Table'[Date]); 'Table'[Date])

VAR _max = MAXX(VALUES('Table'[Date]); 'Table'[Date])

RETURN

CALCULATE(SUM('Table'[Value]); FILTER(ALL('Table'[Date]); 'Table'[Date] = _min)) -

CALCULATE(SUM('Table'[Value]); FILTER(ALL('Table'[Date]); 'Table'[Date] = _max))

Ricardo

[Anonymous]

@camargos88 worked perfectly thank you!!

[az38]

Hi @Anonymous 

try a measure

Measure = 
var _minDate = MIN('Table'[Date])
var _maxDate = MAX('Table'[Date])
return 
MAXX(FILTER('Table','Table'[Date]=_maxDate),'Table'[Amount]) - 
MAXX(FILTER('Table','Table'[Date]=_minDate),'Table'[Amount])

[Anonymous]

@az38 this makes sense but I am getting the incorrect output

[amitchandak]

@Anonymous , prefer to use a date calendar for dates

Try like

Measure =
var _min = minx('Date','Date'[Date])
var _max = maxx('Date','Date'[Date])
return
calculate(Table[Value],filter('Date','Date'[Date]=_min))- calculate(Table[Value],filter('Date','Date'[Date]=_max))

Or

Measure =
var _min = minx('Date','Date'[Date])
var _max = maxx('Date','Date'[Date])
return
calculate(Table[Value],filter(all('Date'),'Date'[Date]=_min))- calculate(Table[Value],filter(all('Date'),'Date'[Date]=_max))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/