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 ...
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

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