Forum Discussion
No Syntax Errors but Query Won't Work
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.
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. |
Still getting an error message. This is the first power query ive ever done, and I dont know coding so I have been running intop uncountable amounts of trouble which can be frustrating. I just want this to work! Im close to paying you to help me out on this code, but this is my last step I just need to correct this syntax error
Anonymous
You didn't copy correctly. Substitute all that you have from #"Removed Duplicates" onwards with the code I provided on my previous post. Otherwise share the pbix and we'll fix it quickly
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.