1 of 1 people found this helpful
How about not returning an actual measure for each calculation, but rather something like:
IF DATEDIFF('month', [Baseline Date], [Appointment Date]) = 0 THEN "Baseline Date"
ELSEIF DATEDIFF('month', [Baseline Date], [Appointment Date]) <= 6 THEN "6 Month"
ELSEIF DATEDIFF('month', [Baseline Date], [Appointment Date]) <= 12 THEN "12 Month"
Then just drop this on Columns, Measure Names on Rows, and Measure Values on Text. You could use additional logic if the 12 month is supposed to also include the values in 6 month, etc (potentially multiple sheets with different date range filters), but it allows you to create a calculation which determines the range agnostic of the measure type, which prevents you from having to create multiple calculations for every single measure.
This is perfect. Thank you!
Glad it helped! If you will mark the answer as correct it will help others find the correct answer more easily in the future as well as marking the question as solved
Thanks; I'm new here.