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.