cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Andy1927
Frequent Visitor

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 expected' with the ^ just below the comma after LocalNow()), below. 

 

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

 

I'm quite new to PowerBI and I've tried suggestions from related questions already posted but no joy - how do I fix this and / or is there a better way of doing this?

 

Many thanks,

 

Andy

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@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")



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
amitchandak
Super User IV
Super User IV

@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")



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

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?

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors