Top 10 Customer sorted by Year

[Sebastian]

Hi Community,

I need help. I have a Sales-Table which consists of all sales a Customer has done.

The table looks like

Number       Name       Date                invoice amount

10000         Müller      01.01.2015      50$

10000         Müller      14.05.2015      75$

10001         Meier       09.02.2015     100$

10001         Meier      15.11.2014      50$

10001         Meier      10.10.214        50$

10002         Hans      15.12.2015      200$

10002        Hans       05.05.2014      500$

I try to get the Top N Customer sorted by Year. Could Anyone help?

Thanks

Sebastian

[konstantinos · Accepted solution]

Check this http://community.powerbi.com/t5/Desktop/Top-15-in-a-report/m-p/8632#M1470

[Sebastian]

Hi Konstantinos,

that is excactly the solution i have looking for.

Thanks a lot and have a nice day.

[konstantinos]

Welcome..Glad that helped