Insurance - Loss Triangles

[PowerPaddy]

Hi,
I was wondering if anyone has had any success in creating insurance Loss triangles in PowerBi? A typical claims loss triangle would show how losses develop over time for each period they were written in. eg...

Easy enough to create in Excel but I'm struggling in PowerBI and I can't find any custom visualisations.

Any advice greatly appreaciated, thanks

[vm_pbi]

Hi, might want to look at the follwoing blog - 

https://insurancedatainsights.blog/2024/02/16/insurance-triangles-in-power-bi/

[Anonymous · Accepted solution]

Hi @PowerPaddy,

It is possible to create triangular matrix visual in power, you can refer to below sample to achieve your requirement.

Prerequisite: matrix preview visual, two table without relationship.

Measure:

Measure = 
var current_Row=MAX('Row'[Row])
var current_Column=MAX('Column'[Column])
return
if(current_Row+current_Column<=13,current_Row*current_Column) 

Regards,

Xiaoxin Sheng

[anupampandey]

Hi @PowerPaddy,

Could you share some sample data please?

Thanks