Forum Discussion
Calculate Min Values within a Specific and Dynamic Date Range
Would you try this : FY End Date = EOMONTH(TODAY(),-1) - 7
This should calculate the end date dynamically
And then use the updated formula in the CALCULATE function:
Test Column = CALCULATE(MIN('Table'[zValus]), 'Table'[RP] > [FY Start Date] && 'Table'[RP] < [FY End Date])
Sincere thanks Anonymous ! Although your code was not exactly what I needed, it was enough to get me where i needed to be. I will see if it does what I think it will next week. Counting that as a solution for you. This is what I ended up using to limit my data dynamically.
End Date Filter (T/F) = 'Table'[RP] <= EOMONTH(DATE(YEAR(TODAY()),MONTH(TODAY()),7),-2)// Looking at the reporting period (RP) entered on the form... RP is less than or equal to the current year and month two months before the 7th of month... after the 7th of this month the data ends on the prior month.
Sincere thanks Anonymous ! Although your code was not exactly what I needed, it was enough to get me where i needed to be. I will see if it does what I think it will next week. Counting that as a solution for you. This is what I ended up using to limit my data dynamically.