last sales by client

[lmiguez]

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 know how can I do this?

Thank you very much.

Best regards,

Lucía

[Zubair_Muhammad · Accepted solution]

Hi @lmiguez

Try adding a RANK calculated column....(RANKING transactions for each CLIENT by date)

Then you can choose RANK(1,2,3) as your filters

RANK =
RANKX (
    FILTER ( Table1, Table1[Client] = EARLIER ( Table1[Client] ) ),
    Table1[Date],
    ,
    DESC,
    DENSE
)

[Zubair_Muhammad · Accepted solution]

Hi @lmiguez

Try adding a RANK calculated column....(RANKING transactions for each CLIENT by date)

Then you can choose RANK(1,2,3) as your filters

RANK =
RANKX (
    FILTER ( Table1, Table1[Client] = EARLIER ( Table1[Client] ) ),
    Table1[Date],
    ,
    DESC,
    DENSE
)

[lmiguez]

Hi @Zubair_Muhammad

Thanks for your reply. It works perfectly but I need to do this through a measure because I need to interact with date slicer.

Do you know how can I do that?

Best regards,

Lucía

[Zubair_Muhammad · Accepted solution]

@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
)

[lmiguez]

@Zubair_Muhammad Thak you very much!

Best regards,

Lucía