Latest date of the correct month for each customer

[IvanZaykov]

Hello,

I would like to get the latest value of each month for a customer.

Here's an example of the data I'm looking at:

The result should look like below:

I tried a few different approaches but I can't get it to work
https://community.powerbi.com/t5/Desktop/How-to-select-a-Max-Value-in-a-given-month-for-each-custome...

Any help would be appreciated. 

[v-danhe-msft]

Hi @IvanZaykov,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @IvanZaykov,

Based on my test, you could refer to below formula:

Measure = CALCULATE(SUM(Table1[Column1]),FILTER('Table1','Table1'[Month]=ENDOFMONTH('Table1'[Month])))

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He