Future Date calculation in powerquery

[jdevar243]

Hi,

I am new to Power BI and need assistance to achieve this below requirement and appreciate any help.

I have a Status column with (A,B,C) values and a created date (Values when a record is created). Now,I need to create another date column (Future Date) with these conditions.

When Status = 'A' then Future_date = (Created_Date + 6 months) else

Status ='B' then Future_date=(Created_Date+3months) end.

Thanks again for your help. 

[jdevar243]

Thank you. Appericate your response.

[FreemanZ · Accepted solution]

Hi @jdevar243 ，

in Power Query, try to add a custom column like:

= if [status] = "A" then Date.AddMonths ([Created_Date], 6) 

else if [status] = "B" then Date.AddMonths ([Created_Date], 3)

else [Created_Date]

or with DAX,  add a calculated column like:

Column = 

SWITCH(

    TRUE(),

    [Status] = "A", EDATE([Created_Date], 6),

    [Status] = "B", EDATE([Created_Date], 3),

    [Created_Date]

)