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])
parry2k's avatar
parry2k
Super User
8 years ago

Can you share the screen shot what you put in filter for relative date filter?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

I'm trying to simplify things with the example data.

The Relative filter I've just created uses the Accounting Period Start Date.

This is because there are no dates in the development periods table.

Each Value havs a development period derived from the Accounting period of the transaction:

 

Thank you