Modify existing DAX formula to look at anything between 91 days to 180 days as the true

[krichmond]

I need help modifying an existing DAX formula (below) so that it looks at anything between 91 days to 180 days as the true and anything 181 days and greater as a false.

180 Day Date Designator = IF(DATEDIFF(mv_perfex[startdate],TODAY(),DAY)<=180,"True","False")

[tamerj1 · Accepted solution]

Hi @krichmond 

please try

180 Day Date Designator =
VAR Difference =
    DATEDIFF ( mv_perfex[startdate], TODAY (), DAY )
RETURN
    IF ( Difference >= 91 && Difference <= 180, "True", "False" )