Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
This is the measure I tried but it retrieves the fist date in the date table
Solved! Go to 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 ()
)
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.
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 ()
)
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |