Forum Discussion

GON76's avatar
GON76
Helper III
1 year ago
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])...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    1 year ago

    Hi,

    Write this calculated column formula

    =if(or('V_Enrollments'[Exitdate]=blank(),'V_Enrollments'[Exitdate]<=edate(today(),-36)),"Not compliant","Compliant")

    Hope this helps.

v-priyankata's avatar
v-priyankata
Community Support
1 year ago

Hi GON76 

I wanted to check if you had the opportunity to review the information provided by users. Please feel free to contact us if you have any further questions.

 

v-priyankata's avatar
v-priyankata
Community Support
1 year ago

Hi GON76 

Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.