Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Simple leap year calculations for returning days in year and whether or not a year is a leap year.
DaysInYear
DaysInYear = VAR __Year = INT(MAX(Years[Year])) VAR __Div4 = IF(MOD(__Year,4)=0,TRUE(),FALSE()) VAR __Div100 = IF(MOD(__Year,100)=0,TRUE(),FALSE()) VAR __Div400 = IF(MOD(__Year,400)=0,TRUE(),FALSE()) VAR __IsLeapYear = IF(__Div4 && NOT(__Div100),TRUE(),IF(__Div4 && __Div100 && __Div400,TRUE(),FALSE())) VAR __DaysInYear = IF(__IsLeapYear,366,365) RETURN __DaysInYear
IsLeapYear
IsLeapYear = VAR __Year = INT(MAX(Years[Year])) VAR __Div4 = IF(MOD(__Year,4)=0,TRUE(),FALSE()) VAR __Div100 = IF(MOD(__Year,100)=0,TRUE(),FALSE()) VAR __Div400 = IF(MOD(__Year,400)=0,TRUE(),FALSE()) VAR __IsLeapYear = IF(__Div4 && NOT(__Div100),TRUE(),IF(__Div4 && __Div100 && __Div400,TRUE(),FALSE())) RETURN __IsLeapYear
eyJrIjoiNmJjYTVlY2UtZTIyZS00NWU5LThkZTAtMjg3MTUwYjlmNDdlIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9