Forum Discussion
Need Help with getting most recent version from a column for compliance
Hi, Mjurado
You can enter into Query Editor, choose your query and go to Transform->Group By, setting like the picture below.
Best Regards,
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Mjurado
You can enter into Query Editor, choose your query and go to Transform->Group By, setting like the picture below.
Best Regards,
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you v-alq-msft this did give me the correct information i needed.
To add on to this , is there a way i can place this in a custom column within an established Query?
When i tried the method you provided by "grouping" it made the rest of the Query columns dissapear, in the end i had to duplicate the Query and apply this group then link the Queries together by username.
Before Group by MAX versionbefore actionAfter MAX version
Is there a way i can insert this information you provided into a column at the end of the original Query instead?
and again Thank you for responding to my question, i really apprecaite the help!
