In Excel I have made a form for calculate the Christian holidays like this:
=IF(OR[DATE]=IF([YEAR]<>2079,ROUNDDOWN(DATE([YEAR],5,DAY(MINUTE([YEAR]/38/)/2+56)),7)-34,ROUNDDOWN(DATE([YEAR],5,DAY(MINUTE([YEAR]/38)/2+57)),7)-34,"TRUE", "")
When creating a new column [HOLIDAYS] in Power Query I have made the form:
if [DATE]=Number.Round(#date([YEAR],5,Date.Day(Time.Minute([YEAR]/38)/2+56)),7,RoundingMode.Down)-34 and [YEAR]<>2079 then "TRUE" else if [DATE]=Number.Round(#date([YEAR],5,Date.Day(Time.Minute([YEAR]/38)/2+57)),7,RoundingMode.Down)-34 and [YEAR]=2079 then "TRUE" else null
Please help me to solve the problem of Expresion-error with using the Time.Minute-function.
=IF(OR[DATE]=IF([YEAR]<>2079,ROUNDDOWN(DATE([YEAR],5,DAY(MINUTE([YEAR]/38/)/2+56)),7)-34,ROUNDDOWN(DATE([YEAR],5,DAY(MINUTE([YEAR]/38)/2+57)),7)-34,"TRUE", "")
When creating a new column [HOLIDAYS] in Power Query I have made the form:
if [DATE]=Number.Round(#date([YEAR],5,Date.Day(Time.Minute([YEAR]/38)/2+56)),7,RoundingMode.Down)-34 and [YEAR]<>2079 then "TRUE" else if [DATE]=Number.Round(#date([YEAR],5,Date.Day(Time.Minute([YEAR]/38)/2+57)),7,RoundingMode.Down)-34 and [YEAR]=2079 then "TRUE" else null
Please help me to solve the problem of Expresion-error with using the Time.Minute-function.