Forum Discussion
Add column showing max value from another column
A quick work around was to create a separate SQL query and group by Opportunity and MAX index then merged the queries. Not sure if it's the most efficient but I am now getting the data I need. Thank you for taking the time.
You are going to need to provide some code samples or what the errors are. You just show the word "error" which may be a problem with how you are using it, or you may be missing a comma. No idea.
Paste your data into the ENTER DATA feature of Excel or Power BI, do your code through the error place, and paste that code.
I cannot use your code sample above because I have no clue what the code through PrevDateTable did.
A quick work around was to create a separate SQL query and group by Opportunity and MAX index then merged the queries. Not sure if it's the most efficient but I am now getting the data I need. Thank you for taking the time.