Return value from Date table based on current date

[bignadad]

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()))

[Ashish_Mathur]

Hi,

Share some sample data to work with (in a format that can be pasted in an MS Excel file) and show the expected result.

[jdbuchanan71 · Accepted solution]

It seems like this one should work. Is there maybe a filter on the dates tables somewhere else?  Maybe try this.

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

Or maybe your MasterDate table does not include today meaning it is cutting off before today?

I tested something similar in a sample file and got what I would expect:

Today Month Year =
CALCULATE ( 
    MAX ( Dates[Mth-Year] ),
    ALL ( Dates ),
    Dates[Date] = TODAY ()
)