Forum Discussion

Frequent Visitor

8 years ago

Solved

last sales by client

Hi, I hope you can help me. I have a table with number of sale id, sales ammount, date and client. I need to make a table visualization with each client and the last 3 sales to each client. Do you...

Need Help

Zubair_Muhammad

Community Champion

8 years ago

lmiguez

May be you can use this RANK measure and use it as a VISUAL filter for top3

Please see attached file as well

RANK Measure =
RANKX (
    FILTER (
        ALLSELECTED ( Table1 ),
        Table1[Client] = SELECTEDVALUE ( Table1[Client] )
    ),
    CALCULATE ( MAX ( Table1[Date] ) ),
    ,
    DESC,
    DENSE
)

last sales by client.pbix48 KB