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

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

4 Replies

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

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