As you didn’t provide the sample dataset and you didn’t tell about your measure formula I just consider a sample dataset on my own to simulate your problem.
Consider following screenshot with data and calculated columns.
Here the DaysFromToday calculate the Day difference from Today to for every column if the corresponding value in ‘SomeValue’ field reached a certain number. SomeValue is also calculated field that you can replace with your own calculation.
Yellow highlighted is the DAX way of mentioning a field name with the table name that you are missing in your formula.
Lastly the MAX or MIN measure can be displayed in the report like following –
CLICK HERE to find out more related problems solutions.