Forum Discussion
No Syntax Errors but Query Won't Work
The Image above is of my Advanced Editor. I have no syntax errors, but get an error message after clicking done. All of the lines are necessary, and the bulk of them add custom columns to retri...
Anonymous
Update the bit from #"Removed Duplicates" onwards:
#"Removed Duplicates" = Table.Distinct(#"ClearNulls", { "DATE" } ), LastStep_ = Table.SelectRows(#"Removed Duplicates", each [date] >= List.Min(#"Removed Duplicates"[date]) and [date] <= Date.AddYears(List.Min(#"Removed Duplicates"[date]),5)) in LastStep_Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Remove the second end parentheses from the Table.ColumnNames step. Also, the "and" between the last two steps should just be a comma. And you have to then name your last step. Finally, your "in" statement should reflect the name of that new last step.
--Nate