Filter 12 month of data

[Anonymous]

Hi Team,

I need to show the data greater then current month and less then - 12 month.

Month	data
2019-03	15
2019-04	10
2019-05	12
2019-06	23
2019-07	12
2019-08	21
2019-09	54
2019-10	62
2019-11	26
2019-12	54
2020-01	4
2020-02	54
2020-03	53
output
2019-04	10
2019-05	12
2019-06	23
2019-07	12
2019-08	21
2019-09	54
2019-10	62
2019-11	26
2019-12	54
2020-01	4
2020-02	54

[Ashish_Mathur]

Hi,

I have solved a similar question here - Flex a Pivot Table to show data for x months ended a certain user defined month.

Hope this helps.

[Anonymous]

Hi Ashish,

I am not able to open the excel which you have provided. Can you please let me know how we can implement ths using DAX expression.

Thank,

Rajveer

[Ashish_Mathur]

Hi,

What problem are you facing in opening the file?

[Anonymous · Accepted solution]

Thanks ashish for your input. i got the solution by the below DAx code.

work = var y=CALCULATE(SUM(Append1[data]),FILTER(Append1,Append1[Month]<Value(max(Append1[Month]))&& Append1[Month]>TODAY()))

Return y

Thanks,

Rajveer.