Forum Discussion

Jimmy_Chacko's avatar
Jimmy_Chacko
New Member
3 years ago
Solved

Limiting data

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.

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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