Forum Discussion

Andy1927's avatar
Andy1927
Helper I
5 years ago
Solved

Simple Conditional Column on Today's Date - Power Query

Hi, I want to add a column using Power Query that shows anything before Todays date = "expired" else "live"   I have this code but im getting an error saying 'Expression.SyntaxError: Token Then ex...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    5 years ago

    Andy1927 , there is addition comma , removed here 

    if [Agreement End Date] <= DateTime.Date(DateTime.LocalNow()) then "Expired" else "Live"

     

    or

     

    = Table.AddColumn(#"Added Conditional Column", "Historic", each if [Agreement End Date] <= DateTime.Date(DateTime.LocalNow()) then "Expired" else "Live")

amitchandak's avatar
amitchandak
Super User
5 years ago

Andy1927 , there is addition comma , removed here 

if [Agreement End Date] <= DateTime.Date(DateTime.LocalNow()) then "Expired" else "Live"

 

or

 

= Table.AddColumn(#"Added Conditional Column", "Historic", each if [Agreement End Date] <= DateTime.Date(DateTime.LocalNow()) then "Expired" else "Live")

Andy1927's avatar
Andy1927
Helper I
5 years ago

Many thanks!

 

I have one additional request and I'm not sure if it requires a new separate ticket? I have previously used the data model to create 'date bandings' e.g. 0-6 mths, 7-12 mths, and so on. I would like to do the same in query editor using the Agreement End Date  - is this possible? If so, is there an example I could use?