Return value from Date table based on current date

Question

This seems so simple but its not working.

I have a MasterDate table and I am trying to find the first Date for the Incentive Quarter.

The incentive quarter is based on today's date which would be 3 in this case.

So i need to find the min date where the incentive quarter and year equals todays date.

In this case it would be 12/1/2023

I tried this measure to retreive the current incentive quarter but it wont work. it's blank

thisQtr = CALCULATE(MAX(MasterDate[Incentive Quarter]),MasterDate[Dates]=TODAY())

This is the measure I tried but it retrieves the fist date in the date table

First Day Qtr =

var thisQtr = CALCULATE(MAX(MasterDate[Incentive Quarter]),MasterDate[Dates]=TODAY())

RETURN

CALCULATE(MIN(MasterDate[Dates].[Date]),MasterDate[Incentive Quarter]=thisQtr,MasterDate[Year]=YEAR(TODAY()))

jdbuchanan71 · Accepted Answer

It seems like this one should work. Is there maybe a filter on the dates tables somewhere else?&nbsp; Maybe try this.
&nbsp;
thisQtr =
CALCULATE (
    MAX ( MasterDate[Incentive Quarter] ),
    ALL ( MasterDate ),
    MasterDate[Dates] = TODAY ()
)
&nbsp;
Or maybe your MasterDate table does not include today meaning it is cutting off before today?
&nbsp;
I tested something similar in a sample file and got what I would expect:
&nbsp;
Today Month Year =
CALCULATE ( 
    MAX ( Dates[Mth-Year] ),
    ALL ( Dates ),
    Dates[Date] = TODAY ()
)
&nbsp;

&nbsp;

Forum Discussion

Return value from Date table based on current date

2 Replies

Related content

Measure returning incorrect value

Date Different return wrong value

MAXX Returning duplicate values

Return "Specific value" from table 1, if not found, return value from table 2

Create Measure to Return Highest Value