Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
My below query is not working, it says I can give only 3 filter conditions for OR.
Loan Number MTD = IF(Enco[Current_Month_FileStarted] = 1 || Enco[Current_Month_Application] = 1|| Enco[Current_Month_Processing] =1 || Enco[Current_Month_Submitted] =1 || Enco[Current_Month_CondApproval] =1, Enco[Current_Month_PreCTC] = 1 || Enco[Current_Month_CTC] =1, Enco[Current_Month_DocsOut] =1 || Enco[Current_Month_FundingDate] =1 , Enco[Loan_Number], BLANK())
Any other way I can apply multiple OR conditions?
Thanks,
Shikha
Solved! Go to Solution.
If the || operator is not working, you will have to nest multiple ORs
Measure = IF( OR (CondA, OR (CondB, OR(CondC, CondD))), TRUE, FALSE)
Hope this helps
David
What error are you getting?
Try thi s:
Loan Number MTD = IF(OR(Enco[Current_Month_FileStarted] = 1 ,
Enco[Current_Month_Application] = 1, Enco[Current_Month_Processing] =1
, Enco[Current_Month_Submitted] =1 , Enco[Current_Month_CondApproval] =1
, Enco[Current_Month_PreCTC] = 1 , Enco[Current_Month_CTC] =1
, Enco[Current_Month_DocsOut] =1 , Enco[Current_Month_FundingDate] =1)
, Enco[Loan_Number], BLANK())
I am getting this error for the query I posted, Too many arguments were passed to the IF function. The maximum argument count for the function is 3.
If the || operator is not working, you will have to nest multiple ORs
Measure = IF( OR (CondA, OR (CondB, OR(CondC, CondD))), TRUE, FALSE)
Hope this helps
David
Thanks David, it worked!! This community is great.
I am trying your way, but it says we can only put two arguments in OR(Logical 1, Logical 2).
Any other suggestion?
User | Count |
---|---|
94 | |
89 | |
79 | |
77 | |
71 |
User | Count |
---|---|
116 | |
107 | |
88 | |
64 | |
63 |