Forum Discussion
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 data.
( it should show latest month values with employee name - need only may'23 data) if user select slicer month then relevant month should show
please suggest: measure
_Latest Month Count = VAR endDate = MAX(table[MonthDate])
RETURN
CALCULATE(sum ( [sales]),table[MonthDate] = endDate)
8 Replies
MSuser5Hi All,
Kindly help me on this with employer name i need to show latest month values only... When i applied above measure then all the months data appearing please suggest on this.
- Ashish_Mathur
Super User
Hi,
Share raw data in a format that can be pasted in an MS Excel file.
- MSuser5
Hi 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.
