topic Date and Time in Developer

Date and Time

Anonymous — Tue, 12 Oct 2021 12:57:14 GMT

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)

Re: Date and Time

Fowmy — Tue, 12 Oct 2021 13:04:44 GMT

@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() )

Re: Date and Time

Anonymous — Tue, 12 Oct 2021 13:26:03 GMT

Thank you.It's working.

Re: Date and Time

Anonymous — Mon, 25 Oct 2021 06:27:56 GMT

Hi,

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

Re: Date and Time

Anonymous — Mon, 25 Oct 2021 09:56:08 GMT

Hi,

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