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 calculate any values which are greater than todays month (developmentperiodkey Rows) highlighted in RED based on the Year (Columns). but don't have the DAX skills to do it, not for the want of trying...

 

The code for the measure is currently:

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

Any help would be greatly appreiated.

 

Many thanks. 

Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    Try this

     

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

12 Replies