Hi All,
I would need the first unique Ticket based on the start/created date of the ticket to be shown as 1 and remaining tickets with the same ticket number which are duplicates to be shown as 0.
This needs to be achieved via Powerquery but should be done without using Merge option.
Attached is the same format and expected result.
Would appreciate, if any help could be provided on the same.
Let me know for any clarifications.
Regards,
Yadavagiri
Hi Yadavgiri,
I hope I have done what you requested.
Table1 does not match your expected result, so the resultant PQ in sheet 'Table2' won't match exactly it unless you change your data source, but the procedure in PQ is ok.
Formula:
Please Login or Register to view this content.
Last edited by DJunqueira; 12-19-2023 at 07:33 PM.
Hello DJunqueira,
Many thanks for this and it really worked on my data. Closing this thread. Appreciate your help!Have a good day! Take care!
Last edited by Yadavgiri; 12-20-2023 at 10:00 AM.
Glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks