DOJ_FY =
(if (MONTH(MAX(’employees'[doj]))<=3,
YEAR(MAX(’employees'[doj]))-1,
YEAR(MAX(’employees'[doj])
))) & ” – ” & (if (MONTH(MAX(’employees'[doj]))<=3,
YEAR(MAX(’employees'[doj])),
YEAR(MAX(’employees'[doj]))+1
))
DOJ_FY =
(if (MONTH(MAX(’employees'[doj]))<=3,
YEAR(MAX(’employees'[doj]))-1,
YEAR(MAX(’employees'[doj])
))) & ” – ” & (if (MONTH(MAX(’employees'[doj]))<=3,
YEAR(MAX(’employees'[doj])),
YEAR(MAX(’employees'[doj]))+1
))
Leave a Reply