Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
jdevar243
New Member

Future Date calculation in powerquery

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. 

1 ACCEPTED SOLUTION
FreemanZ
Super User
Super User

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]
)

View solution in original post

2 REPLIES 2
jdevar243
New Member

Thank you. Appericate your response.

FreemanZ
Super User
Super User

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]
)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.