If statement Help

[Centaur]

Hello, I am getting an error in this IF statement.  I have tried "IF" and "IIF".  Do you happen to see where I am  wrong?  I am wanting to add a custom column to tag rows that are greater than the current date - 8 days.  maybe there is a better way to do this. I do not see how I can filter my [Date] column for the criteria unless I add a helper column as below. 

= Table.AddColumn(#"Sorted Rows", "Filter Grtr 8 days", each IIF((NOW()-[Date])<8,"Y","N"))

[BA_Pete]

Hi @Centaur ,

The correct IF statement syntax in Power Query is ' if..then..else if..else'.

I think your statement would need to be something like this:

if Duration.Days(DateTime.LocalNow() - [Date]) < 8 then "Y" else "N"

Pete

[Centaur]

Hi Pete,

thank you. I get an error though "2 arguments were passed...."?  

[BA_Pete · Accepted solution]

Hi @Centaur ,

I already updated my code to correct this when I spotted it.

Also, based on your reply to jennratten, I think you will need to add a Date.From function to truncate the datetime value of today:

if Duration.Days(Date.From(DateTime.LocalNow()) - [Date]) < 8 then "Y" else "N"

Pete

[jennratten]

Here you are (assuming your date field is actually a datetime type.  If it is not, you will need to use Date.From ( DateTime.FixedLocalNow() 😞

= Table.AddColumn(#"Sorted Rows", "Filter Grtr 8 days", each if Duration.Days ( DateTime.FixedLocalNow()-[Date] ) < 8 then "Y" else "N", type text )

[Centaur]

Hi Jenn,

I also have an error:

Not sure if I have done somethng wrong on my end. I added a custom column then pasted.