Find last date that exist in my list by each month

[jaco1951]

Dear all

I have a list of currency rates, and I need to pull the last date of currency rates from each month, so EndOfMonth is not working in this case.

I have tried with this forumla, but it doesn't seem to give any results:

endOfMonth_1 =
CALCULATE(

MAX(CurrencyRates[Date_Currency]);

ALLSELECTED(currencyRates[YearMonth])

)

Does anyone have ideas on how to pick this date and to show the Currency_Value based on this selection?

Kind regards

Espen

[Zubair_Muhammad · Accepted solution]

Hi @jaco1951

Please see attached file here

Hope it helps

This is the Measure I used

EndOfMonth_rate =
VAR Last_Date =
    ENDOFMONTH ( VALUES ( CurrencyRates[Date] ) )
RETURN
    CALCULATE (
        SELECTEDVALUE ( CurrencyRates[Rate] ),
        CurrencyRates[Date] = Last_Date
    )

[jaco1951]

Thank you very much!