Hi, I am trying to find the error in the following syntax in which I am trying to use in Power Bi. This formula gives me an "ERROR".
This is a Dax function Please assist.
Logged Quarter = IF(OR(MONTH('Case Data'[Date Logged])=7,MONTH('Case Data'[Date Logged])=8),MONTH('Case Data'[Date Logged])=9,"Q1", IF(OR(MONTH('Case Data'[Date Logged])=10,MONTH('Case Data'[Date Logged])=11,MONTH('Case Data'[Date Logged])=12),"Q2", IF(OR(MONTH('Case Data'[Date Logged])=1,MONTH('Case Data'[Date Logged])=2,MONTH('Case Data'[Date Logged])=3),"Q3", IF(OR(MONTH('Case Data'[Date Logged])=4,MONTH('Case Data'[Date Logged])=5,MONTH('Case Data'[Date Logged])=6),"Q4","unknown"))))
Thank you in advance.