Forum Discussion
MSuser5
Helper III
Helper IIILatest month data not showing
Hi All, Have quick question i have created measure which is showing latest month value (will be May'2023) it's working fine. But when i add employee name in the table it's showing all the months...
Ashish_Mathur
Super User
Super UserHi,
Share raw data in a format that can be pasted in an MS Excel file.
MSuser5Helper III
Helper IIIHi Ashish,
Please find the sample raw data and expect
ed result. I want to show latest month (default ) top 3 names.. if user required they can select months in slicer.
| Name | Sales | MonthDate |
| AAA1 | 125453 | 01/01/2023 |
| DDD | 18116 | 01/02/2023 |
| BB1 | 15373 | 01/01/2023 |
| AAA1 | 15359 | 01/03/2023 |
| CCC | 14647 | 01/02/2023 |
| FFFF | 13736 | 01/03/2023 |
| DDD | 13262 | 01/01/2023 |
| RRR | 12784 | 01/03/2023 |
| RRR | 12771 | 01/02/2023 |
| TTT | 12761 | 01/03/2023 |
| EEE | 12533 | 01/01/2023 |
| AAA1 | 12209 | 01/04/2023 |
| EEE | 11697 | 01/02/2023 |
| RRR | 11583 | 01/04/2023 |
| TTT | 11071 | 01/04/2023 |
| EEE | 9990 | 01/04/2023 |
| FFFF | 9925 | 01/01/2023 |
| DDD | 9810 | 01/05/2023 |
| FFFF | 9716 | 01/05/2023 |
| TTT | 7934 | 01/05/2023 |
| YYY | 7723 | 01/05/2023 |
| EEE | 7440 | 01/05/2023 |
Expected as default resulrt to be :
Thanks for your support.
- Ashish_Mathur
I am still not clear about what you want but here's a start. Download the attached file.
Hope this helps.
- MSuser5
Hi Ashish_Mathur ,
Thanks for the update, As same result i want to show only latest month data in the table chart if user required to see any other month then they will select from month sclier.
So how to show default latest month only.
Thanks,
- Ashish_Mathur
You are welcome. It is easier to just select the latest or any other month in the slicer.