Select the most recent value based on a slicer period

[fernando_solis]

Hi everyone,

I am building a model which displays the electricity prices, demand and expenditure on a determined region. I am using a map to achieve this goal. Currently, the map that I have already built shows the location of different nodes, the name of those nodes and the average expenditure and average demand of each one of them. The map is connected to a date slicer, which I use to select the desired date range of all this data. 

One of the requirements is to always show the latest monthly price on each node, based, of course, on the date range selected in the slicer, for example:

Date Range (Slicer)          NodeName      Avg(expenditure)     Avg(demand)      LatestPrice (January 2018 price)

2017-01-01 / 2018-01-31       qwerty        12345.69             789456.32         1.89

I have all this data stored in one single table that looks like this:

Date               NodeName                Expenditure             Demand              Price
2017-01-01          qwerty                   123.65                321.21               0.56
2017-02-01           abc                     321.56                135.98               0.89
...
2018-01-01          qwerty                   5489.4                546.68               1.89

I am sure that there is a DAX solution for this, I have tried some that I have found in this forum but none of them have worked 😞

I would really appreciate your help!

[Zubair_Muhammad · Accepted solution]

@fernando_solis

May be somehting on this pattern

Measure =
CALCULATE ( MAX ( TableName[Price] ), LASTDATE ( TableName[Date] ) )

[fernando_solis]

@Zubair_Muhammad

Thank you so much! This was what I was looking for!