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 

Thank you for reaching out to the Microsoft Fabric Forum Community.

andrewsommer MohamedFowzan1 Ashish_Mathur Bmejia Thanks for your inputs.

I hope the information shared by other users was helpful. Have you had a chance to try it? Are you experiencing any other issues? If you have more questions, feel free to ask the community.

 

  • 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.