Forum Discussion

aspitalnick's avatar
aspitalnick
Frequent Visitor
4 years ago
Solved

Help with a formula

I have a column called [Case or Contact] and a field called [Test Collection Date]. I need to create a new column called [immunity period] that if the [Case or Contact] field is "case" adds 90 days t...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    aspitalnick , a new column

     

    In power Query/M

    Immunity period= if [Contact or Case] ="Case" then Date.AddDays([Test Collection Date],90) else null

     

    In DAX
    Immunity period= if( [Contact or Case] ="Case" ,[Test Collection Date] +90 , blank())

amitchandak's avatar
amitchandak
Super User
4 years ago

aspitalnick , a new column

 

In power Query/M

Immunity period= if [Contact or Case] ="Case" then Date.AddDays([Test Collection Date],90) else null

 

In DAX
Immunity period= if( [Contact or Case] ="Case" ,[Test Collection Date] +90 , blank())