Date and Time

[Anonymous]

Hi,

I need to add today's date with one column which will return date column.I have a logic in spotfire and I need to implement in power BI.I am sharing the logic for spotfire

If((left([STATUS],2)="01")
Or (left([STATUS],2)="02")
Or (left([STATUS],2)="04")
Or (left([STATUS],2)="10")
Or (left([STATUS],2)="11")
Or (left([STATUS],2)="13")
Or (left([STATUS],2)="30")
Or (left([STATUS],2)="50")
Or (left([STATUS],2)="60"),
Date(DateAdd("day",[ST_Leadtime level],DateTimeNow())),NULL)

[Anonymous]

Hi,

How to implement the below condition in the Power Query Editor.

If((left([STATUS],2)="01")
Or (left([STATUS],2)="02")
Or (left([STATUS],2)="04")
Or (left([STATUS],2)="10")
Or (left([STATUS],2)="11")
Or (left([STATUS],2)="13")
Or (left([STATUS],2)="30")
Or (left([STATUS],2)="50")
Or (left([STATUS],2)="60"),
Date(DateAdd("day",[ST_Leadtime level],DateTimeNow())),NULL)

[Fowmy · Accepted solution]

@Anonymous 

If you are trying to add a new column then try as follows:

NewColumn = IF( left([STATUS],2) IN {"01","02","04","10","11","13","30","50","60"}, [ST_Leadtime level] + NOW() )

[Anonymous]

Hi,

How to implement the below condition in the Power Query Editor.

If((left([STATUS],2)="01")
Or (left([STATUS],2)="02")
Or (left([STATUS],2)="04")
Or (left([STATUS],2)="10")
Or (left([STATUS],2)="11")
Or (left([STATUS],2)="13")
Or (left([STATUS],2)="30")
Or (left([STATUS],2)="50")
Or (left([STATUS],2)="60"),
Date(DateAdd("day",[ST_Leadtime level],DateTimeNow())),NULL)

[Anonymous]

Thank you.It's working.