Financial Year formula for power BI

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
))


Comments

Leave a Reply

Discover more from Bhulo

Subscribe now to keep reading and get access to the full archive.

Continue reading