cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
wrightsan Occasional Visitor
Occasional Visitor

Insurance loss ratio calculation

Hi there

 

I am new to all things Power BI , and I am building some insurance reporting dashboards.

 

I am looking to build a dashboard which will allow me to calculate the loss ratio and triangles of a particular account. I have an excel file with the raw risk data and a excel file with the claims data (risk file shows the premium and claims file shows the claims). The common factor on both is the vehicle registration number.

 

What I would like to do, is to build a dashboard which matches the vehicle registration number on both files, and then calculates the loss ratio (claims divided by premium), as I would like to show this at portfolio level, but also at a more granular level.

 

I would also like to develop triangles, but again, not sure how I will need to do this.

 

I have not yet figured out how to calculate this, so if any one can help me, it would be appreciated! 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Insurance loss ratio calculation

@wrightsan 

 

You may try using RELATED and RELATEDTABLE.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
lc_finance Senior Member
Senior Member

Re: Insurance loss ratio calculation

Hi @wrightsan ,

 

 

I would be happy to help you.

 

Can you share a sample Power BI file with your source data? Also an example in Excel of the report you want to achieve, including the formulas you use, etc

 

You share it by uploading it to One Drive, Google Drive or another similar tool.

 

Regards,

 

LC

Interested in Power BI and DAX? Check out my blog at www.finance-bi.com

Community Support Team
Community Support Team

Re: Insurance loss ratio calculation

@wrightsan 

 

You may try using RELATED and RELATEDTABLE.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,091)