Forum Discussion

PowerPaddy's avatar
PowerPaddy
Frequent Visitor
9 years ago
Solved

Insurance - Loss Triangles

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 wr...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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