Measure Results Off By 1 Year

[tecumseh]

Hi all,

My Measure is returning 12/31/2025 when I use 

IN ALLSELECTED('Date Table'[QQYY])

I double checked the Slicer. The selected values are Q1 - Q4 for 2024
If I hard code the values in the slicer I get the correct max date 12/31/2024.

What am I doing wrong that is returning 12/31/2025?

Thanks,
-w

KPI Max Date 15M = 
VAR __tbl_Dates =
    SELECTCOLUMNS(
        'Date Table',
        "Date",'Date Table'[Date],
        "Quarter", 'Date Table'[QQYY]
    )
VAR __tbl_Dates_Filtered = 
FILTER(
    __tbl_Dates,
    [Quarter] IN ALLSELECTED('Date Table'[QQYY])
)
VAR __Max_Date = 
MAXX(__tbl_Dates_Filtered,[Date])
RETURN
__Max_Date

[tecumseh]

Thanks @rajendraongole1 ,

That resolved it.

Thanks!
-w

[rajendraongole1]

Happy to Help @tecumseh  !!

[rajendraongole1 · Accepted solution]

Hi @tecumseh -Try checking if your Date Table includes any dates for 2025. If it does, and they aren't filtered out properly, they might be affecting your result.

can you check with below modified measure

KPI Max Date 15M =
VAR __tbl_Dates =
SELECTCOLUMNS(
'Date Table',
"Date",'Date Table'[Date],
"Quarter", 'Date Table'[QQYY]
)
VAR __Selected_Years =
VALUES('Date Table'[Year]) -- for year in the selection
VAR __tbl_Dates_Filtered =
FILTER(
__tbl_Dates,
[Quarter] IN ALLSELECTED('Date Table'[QQYY]) &&
YEAR([Date]) IN __Selected_Years -- Filter only the selected year(s)
)
VAR __Max_Date =
MAXX(__tbl_Dates_Filtered,[Date])
RETURN
__Max_Date

I hope this works