cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Filter 12 month of data

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
1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

4 REPLIES 4
Super User

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Anonymous
Not applicable

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

Super User

Hi,

What problem are you facing in opening the file?

Regards,
Ashish Mathur
http://www.ashishmathur.com
Anonymous
Not applicable

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.