How to get Report Date = Slicer Latest Selected Date

[danyeungw]

I created a measure named "Selected Date' to get the latest selected date from a slicer. The date returned corrected. See Image. I created another measure to assign "Quarter End" or "Current". See the code below.  The "Quarter End" is correct. However, all other rows had "Current". I want the rows with Report Date "3/8/2023" in this example to have "Current".  What is wrong in the code? Or is there another way to do it? Thanks.

Quarters = if(ENDOFQUARTER('Table1'[ReportDate].[Date])= 'Table1'[ReportDate],"Quarter End",if('Table1'[ReportDate].[Date] = [Selected Date],"Current","")) 

Selected Date = LASTDATE('Table1'[ReportDate])

[danyeungw]

I think I know why all rows are Current, but don't know how to fix it. I am thinking if I can get the constant from "Selected Date", it may work. It is 3/4/2023 in this example.
I don't think I can attach a file here.

Quarters = if(ENDOFQUARTER('Table1'[ReportDate].[Date])= 'Table1'[ReportDate],"Quarter End",if('Table1'[ReportDate].[Date] = [Selected Date],"Current",""))

Selected Date = LASTDATE('Table1'[ReportDate])

SelectedDate = FORMAT([Selected Date],"MM/DD/yyyy")

[Ashish_Mathur]

Hi,

Could you share the download link of the PBI file.

[Ahmedx]

write like this:

Quarters=
VAR = _MaxSelectedDate = max('Table1'[ReportDate])
RETURN
Quarters = if(ENDOFQUARTER('Table1'[ReportDate].[Date])= 'Table1'[ReportDate],
 "Quarter End",if('Table1'[ReportDate].[Date] = _MaxSelectedDate,"Current","")) 

[danyeungw]

Thanks @Ahmedx , I got an error "Unexpected expression =" on VAR =. I modified it to the followings. All rows except the "Quarter End" had "Current".

Quarters = if(ENDOFQUARTER('Table1'[ReportDate].[Date])= 'Table1'[ReportDate],
 "Quarter End",if('Table1'[ReportDate].[Date] = max('Table1'[ReportDate]),"Current","")) 

OR

Quarters = if(ENDOFQUARTER('Table1'[ReportDate].[Date])= 'Table1'[ReportDate],
"Quarter End",if('Table1'[ReportDate].[Date] = LASTDATE('Table1'[ReportDate]),"Current",""))