RANKX issues

[Anonymous]

Hello community,

I want to create a Rank or a flag so I can determine only the new or active items within a group, based on a ID, name and status.

How can I achieve that?

thanks

[Anonymous]

Thank you for your answear!

[amitchandak · Accepted solution]

@Anonymous , New item can be based on date, say the first transaction

example 

rankx(filter(Table, [Group] = earlier([Group]) && [Item] = earlier([Item]) ), [Date],,asc,dense)

Now you can flag rank =1 as new 

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures