I have a metric called “launch dates” with different project names.
Project | Launch Date
From this metric (all the values are *date* type), I want to pull the latest date (in this case, 12/10/2022) into a new metric (LatestLaunchDate) to use it in a calculation. A simplified version of what I’m thinking would be:
=IF(Month.Year > LatestLaunchDate, 1, 0)
For any month prior to and including the month with the LatestLaunchDate, one calculation would apply. For any month after the LatestLaunchDate, a different calculation would apply.
I tried a few versions of the MAX and BY MAX modifiers/functions but didn’t get the result I wanted.
Best answer by NathanView original