Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
This is what I have at the moment:
Order = RANKX(FILTER(Table,Table[User] = EARLIER(Table[User])),Table[Month],,ASC)
Any help is really appreciated
Solved! Go to Solution.
@Anonymous , Try a new column like
Order = RANKX(FILTER(Table,Table[User] = EARLIER(Table[User]) && Table[Month] =earlier(Table[Month])),Table[key],,ASC)
@Anonymous , Try a new column like
Order = RANKX(FILTER(Table,Table[User] = EARLIER(Table[User]) && Table[Month] =earlier(Table[Month])),Table[key],,ASC)
It works!, thank you very much
User | Count |
---|---|
98 | |
75 | |
74 | |
49 | |
26 |