Forum Discussion

jdevar243's avatar
jdevar243
New Member
2 years ago
Solved

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 ...
  • FreemanZ's avatar
    FreemanZ
    2 years ago

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

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
2 years ago

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