Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Insurance triangle

  I'm using a matrix to display a triangle.  The triangle is cumulative and currently extends to the maximum developmentperiodkey.   This is all well and good but I want it to blank /hide/not ...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    Try this

     

    Measure = CALCULATE([Value],FILTER(ALL('DevelopmentPeriods'),
    DevelopmentPeriods[DevelopmentPeriodKey]<=MAX(DevelopmentPeriods)))
*
DIVIDE([Value],[Value])