Showing current and the next 2 month

[selimovd]

Hello everyone,

I want to select a date from a slicer and then my measure should only deliver the selected and the 2 next month:

So if I select 2011-08 on my slicer:

Then I want in all tables just to show the selected month and the following 2 month:

Somehow I'm a little stuck.

I can get the highest selected date with: 

max(DimDate[FullDateAlternateKey])

For the measure I tried:

SumSales+3 = 
VAR maxDate = max(DimDate[FullDateAlternateKey])

RETURN
CALCULATE(SUM(FactInternetSales[SalesAmount]); FILTER(DimDate;DimDate[FullDateAlternateKey]>=maxDate && DimDate[FullDateAlternateKey]<DATEADD(DimDate[FullDateAlternateKey];3;MONTH)))

But somehow this doesn't work at all. Can someone help me?

Thank you and best regards

[v-piga-msft]

Hi @selimovd ,

For your requirement, you could refer to this similar thread firstly.

If you still need help, please share your data sample so that we could help further on it.

In addition, here is another reference.

Best  Regards,

Cherry