Top 12 months in Visual based on selection from page level filter

[mthukara]

Dear All,

I have date column as part of the Page filter and not slicers

Users can select a single month in the filter pane; for example 2020-03

I have a bar chart visual which should display last 12 months from the selected Month ( In this case April'19 to Mar'20)

Because of the page level filter bar chart was showing only March 2020

Used ALL in the filter then i can get all the months in the database ( In this case Jan'19 to May'20)

dax - C_EmpCount_Trend = CALCULATE(SUM('emp'[EMPLOYEE_COUNT]),ALL('emp'[SNAP_DT]))

above dax is giving all the months from database but i need to show only last 12 months based on the selection

Kindly help how to apply the flast 12 month filter in to this dax

Thansk!

[AllisonKennedy]

You could try using a DATESBETWEEN or DATESINPERIOD with the MIN(DimDate[Date])

I think DATESINPERIOD would work better for your purpose:
DATESINPERIOD(DimDate[Date], MIN(DimDate[Date]), -12, Month)
https://docs.microsoft.com/en-us/dax/datesinperiod-function-dax

[venal]

As suggested, i tried the same. But it is not working.

I am also having the same issue. Can you please suggest if it is working for you.

[mthukara]

This is not working for me

[AllisonKennedy]

Can you provide a sample report? You might need to use a variable to determine the min date, then use ALL() with the DATESINPERIOD:

C_EmpCount_Trend =
VAR _MinDate = MIN(DimDate[Date])
RETURN
CALCULATE(SUM('emp'[EMPLOYEE_COUNT]),ALL('emp'[SNAP_DT]), DATESINPERIOD(ALL(DimDate[Date]), _MinDate, -12, Month))