Get the last value of a selected month

[saminouari]

Hi,

When I select for example the month of january 2019, I want to get only the last value of that month, in the example below, it should show me 31-01-2020 and the value 30.

I tried with Max(VisitDate) but it didn't work.

[Taoufiq_Zarra]

you can use

=Date(Monthend(VisitDate))

[saminouari]

Your formula didn't work. I used instead 

max(aggr(count({< PDV_ModelName={'Available on EXIT'},PDV_Boolean={1},StoreDisabled={0}>} ProductId&StoreId),StoreId, VisitDate))

It gives me the correct last value of each store if I select for example the month of january 2019, but the total is incorrect.