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!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hello,
I want to know if there is a formula who can do what i want.
Get the last date of meeting for the same client ?
like my exemple i want to have just the last date in my table :
thank you for the futur answer.
Great day
You just answer then no coming back if your first solution didn't work ? @amitchandak
@ItSupportElm , Try a measure like this for date of if need for all other other columns, other than client
finRedndz measure = calculate(lastnonblank(Table[finRedndz],blank()), filter(Table, Table[finRedndz] = calculate(max(Table[finRedndz]), allexcept(Table, Table[numero Client]))))
User | Count |
---|---|
9 | |
8 | |
5 | |
4 | |
3 |