- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Top 10 customer and its respective M-1 and M-2 data
Hi, how to show the Top 10 clients with sales of current month, previous month and last 2 months? For example, when April is selected on the Month slicer, the table shows top 10 clients based on sales amount in April. The table also shows the sales amount for previous month and past 2 months for the current top 10 clients.
Here is the sample data.
Top 10 Client | Sales Amount | Month |
A | 32 | April |
B | 57 | April |
D | 85 | April |
E | 96 | April |
F | 93 | April |
G | 84 | April |
H | 53 | April |
I | 6 | April |
J | 80 | April |
K | 41 | April |
A | 88 | March |
B | 41 | March |
D | 71 | March |
E | 89 | March |
F | 72 | March |
G | 65 | March |
H | 93 | March |
I | 38 | March |
J | 40 | March |
K | 41 | March |
A | 51 | February |
B | 13 | February |
D | 70 | February |
E | 62 | February |
F | 28 | February |
G | 52 | February |
H | 67 | February |
I | 3 | February |
J | 70 | February |
K | 16 | February |
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The question itself is easy enough; but I'd not bother to spend more time making mock-up data than authoring the solution. Paste some copiable mock-up data.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @ThxAlot , thank you for the solution! It works. How about bottom 10? Can you show me how to do it? Thanks a lot! 🙂
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
08-09-2024 06:26 AM | |||
02-21-2024 08:10 AM | |||
03-06-2024 07:52 AM | |||
03-20-2024 03:09 PM | |||
07-01-2024 04:28 AM |
User | Count |
---|---|
118 | |
73 | |
56 | |
56 | |
43 |
User | Count |
---|---|
181 | |
121 | |
82 | |
69 | |
54 |