Forum Discussion
Solved
Using two conditions to return a specific value
I am trying to use two conditions to return a value. I'm using the following formula: Compliance Status = IF(OR ('V_ENROLLMENTS'[EXITDATE].[Date] < EDATE(TODAY(), -3), ISBLANK([EXITDATE])...
Hi,
Write this calculated column formula
=if(or('V_Enrollments'[Exitdate]=blank(),'V_Enrollments'[Exitdate]<=edate(today(),-36)),"Not compliant","Compliant")
Hope this helps.
Hi,
Write this calculated column formula
=if(or('V_Enrollments'[Exitdate]=blank(),'V_Enrollments'[Exitdate]<=edate(today(),-36)),"Not compliant","Compliant")
Hope this helps.