Hello @Shruthi96 ,
I would suggest you to use power query to solve this issue, because with this technique you don't even get the not needed data in your data model. To achieve this, check out this example
let
Source = #table
(
{"Number","Updated"},
{
{"Tkt1 ","43567"}, {"Tkt2 ","43568"}, {"Tkt3 ","43559"}, {"Tkt4 ","43558"}, {"Tkt2 ","43723"}, {"Tkt3 ","43754"}
}
),
ToDate = Table.TransformColumns
(
Source,
{{"Updated", each Date.From(Number.From(_))}}
),
Group = Table.Group
(
ToDate, {"Number"}, {{"MaxUpdated", each List.Max([Updated]), type date}}
)
in
Group
Copy paste this code to the advanced editor to see how the solution works. You can apply the code by pasting a part of it to your query or I can create a custom function for your, and show how to apply it.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
