topic Re: Future Date calculation in powerquery in DAX Commands and Tips

Future Date calculation in powerquery

jdevar243 — Fri, 03 Nov 2023 19:21:54 GMT

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.

Re: Future Date calculation in powerquery

FreemanZ — Sat, 04 Nov 2023 02:40:48 GMT

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]

)

Re: Future Date calculation in powerquery

jdevar243 — Thu, 09 Nov 2023 14:07:04 GMT

Thank you. Appericate your response.