highest (Closed) date to the end of the selected year

[Anonymous]

Hello champs,

I need the closest date to end of the selected year for in {EventDate] in following formulas 

VAR SelectedYear = SELECTEDVALUE('Calendar'[Date].[Year])

YEAR(CecCaseEvent[EventDate]) = SelectedYear

What id does at the moment just selecting a random date in the year in order

CecCaseEvent[EventOrder], DESC

Not sure if that is the closed one to the end of the selected year, that's what I think.

Can you help me how to correct it? 

[ryan_mayu]

could you pls proivde some sample data and expected output?

[Anonymous]

Hello, Ryan

Here I have a picture

I need selected one, in blue ,that's the closed one to the of the year for 2023. OrderID = EventOrder and [EventDate] = Event Date, selected year is 2023

[ryan_mayu]

still not understand your request. Where is the eventorder info? what do you mean eventdate= event date?

[Anonymous]

Hello , I don't know to better explain but I believe it with the MAX formula..

I think I got it this works.

VAR SelectedYear = SELECTEDVALUE('Calendar'[Year])
RETURN
CALCULATE(
MAX(CecCaseEvent[EventDate]),
YEAR(CecCaseEvent[EventDate]) = SelectedYear
)

[Anonymous]

I tried to describe(related columns) on the picture, sorry for confusion.