Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
Thank you for your answear!
@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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |