Limiting data

[Jimmy_Chacko]

Hi,

How to limit the calculation of growth(Eg: Annual growth), where the Fact data table contains only 20 months of data. I mean I don't want to get the growth while the previous year is not having 12 months.

Or in a MAT line graph, the first 11 months' data point is incorrect as it contains only data for less than 12 months and I need to eliminate such calculations.

Appreciate your help.

[Anonymous · Accepted solution]

Hi @Jimmy_Chacko ,

Add an if condition before the calculation of growth.

For example:

measure = 
var count_last_year = calculate(count([month]),filter(table,[year] = selectedvalue([year])-1))
return
IF(count_last_year=12,[growth],blank())

Best Regards,

Jay