cancel
Showing results for
Did you mean:
Helper I

## MIn and Max dates in selection

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:

1 ACCEPTED SOLUTION
Community Support

Hi @almafater2 ,

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

2 REPLIES 2
Community Support

Hi @almafater2 ,

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

Super User IV

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

Proud to be a Super User!

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

#### Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors