cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

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

Thank you very much.

Best regards,

Lucía

2 ACCEPTED SOLUTIONS
Community Champion

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

Regards
Zubair

Community Champion

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

Regards
Zubair

4 REPLIES 4
Community Champion

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

Regards
Zubair

Frequent Visitor

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

Community Champion

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

Regards
Zubair

Frequent Visitor

Best regards,

Lucía