switch true
判斷最近6個月與6個月前的數(shù)據(jù)

Date Periods = 
VAR Datediff = 1 * ( 'table'[tDate] - TODAY () )
RETURN
    SWITCH (
        TRUE(),
        Datediff <= 0 && Datediff >= -180, "Last 6 Months",
        Datediff < 180, "Older than 6 Months"
    )