I am not able to get previous month growth data when I Apply Year Filter.

[SS2929]

Hi, I need help in the growth of the periods mentioned in the table, even if we filter years. Also, how can we remove unwanted values like "infinity" and blank from the column. 

Measure ->% Growth = CALCULATE(([Total Sales]/[Month Yago])-1);

Measure -> Total Sales = SUM('Sales Data'[Volume]);

Measure -> Month Yago = CALCULATE(SUM('Sales Data'[Volume]),PARALLELPERIOD('Sales Data'[Month],-12,MONTH))

[Fowmy]

@SS2929 

Can you share the Measure Gr% here?

You implement is as follows:

IF(
NOT ISBLANK ( [Month Yago] ),
YOUR MEAURE HERE
)

[SS2929]

Shared. Updated this in my query, please have a look