Latest month data not showing

[MSuser5]

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)

[Ashish_Mathur]

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.

[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.

[MSuser5]

@Ashish_Mathur  - Can't we show latest month as default without selecting from slicer.?

[Ashish_Mathur]

Someone else will help you with this.

[MSuser5]

Hi 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.