Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date and Time

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],...
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    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() )
Fowmy's avatar
Fowmy
Super User
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you.It's working.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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)