MIn and Max dates in selection

[Anonymous]

Hi, community,

I am trying to calculate the difference between the biggest and lowest values in this table in the selected range of dates. 

In this case the the desired result would be a dax measure that would calculate:

VerteX on lowest date in selection (31320000)  - VerteX on the biggest date on selection (27380000) = 3940000. 

How do I identify the min and max dates in the selection? 

The formula for VNT VertėX =

CALCULATE(

SUMX('VNT Vertės', 'VNT Vertės'[InvestmentUnitValueEntEY.Unit_Value] * [VNT Skaičius]),

FILTER(ALL(Dates[Date]), Dates[Date] <= MAX(Dates[Date])))

Ataching link with PBI file example:

https://www.dropbox.com/s/z3ve4tk8ujc2g03/Example5.pbix?dl=0

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

You can use the following measure:

Measure = FIRSTNONBLANKVALUE(Dates[EndOfMonth],[VNT VertėX])-LASTNONBLANKVALUE(Dates[EndOfMonth],[VNT VertėX])

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

@Anonymous , try a measure like

measure =
var _max = MAXX(allselected('Dates'), 'Dates'[Date])
var _min = MAXX(allselected('Dates'), 'Dates'[Date])
return
CALCULATE(
SUMX('VNT Vertės', 'VNT Vertės'[InvestmentUnitValueEntEY.Unit_Value] * [VNT Skaičius]),
FILTER((Dates[Date]), Dates[Date] = _max)) - CALCULATE(
SUMX('VNT Vertės', 'VNT Vertės'[InvestmentUnitValueEntEY.Unit_Value] * [VNT Skaičius]),
FILTER((Dates[Date]), Dates[Date] = _min))