Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Add Conditional column based on three dates

Hi All , I need some inputs regarding adding a new field "Status" . I have start date and End Date .  The logic Is , if current date is between startdate and End date then the status is "Active" el...
Need Help
  • jennratten's avatar
    jennratten
    4 years ago

    Sorry, I have updated the script to use your table name.

     

    Table.AddColumn(tablename, "Status", each let today = Date.From ( DateTime.FixedLocalNow() ) in if  [Start_Date] <= today and [End_Date] >= today then "Active" else "Inactive", type text)
jennratten's avatar
jennratten
Super User
4 years ago

Hello!  Here you go:

 

Table.AddColumn(#"Changed Type", "Status", each let today = Date.From ( DateTime.FixedLocalNow() ) in if  [StartDate] <= today and [EndDate] >= today then "Active" else "Inactive", type text)

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    jennratten  Thanks for replying . Im getting this

    "The name 'Changed Type' wasn't recognized. Make sure it's spelled correctly."

    Im new to powerQuery . Any idea what im missing ?