Solved: Insurance triangle - Page 2

Anonymous · ‎07-23-2018

23-07-2018 17-41-08.png

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.

parry2k · ‎07-23-2018

Try this

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

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post