Forum Discussion

mluanacruz's avatar
mluanacruz
Icon for Helper I rankHelper I
4 years ago

Average from the last 3 months - Develop Triangles

Hi All,  Hope I can help with this. I am working on this project where I need to make the triangle analyses in Power BI,    And I got a triangle like this:  But my next step is to ta...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Thank you for providing sample data. Unfortunately it only contains months until 201906.

 

In general you can use EDATE for these computations, specifically EDATE (ACCIDENT_DATE,-DEV_MONTHS)

mluanacruz's avatar
mluanacruz
Icon for Helper I rankHelper I
4 years ago

Hi lbendlin 

I updated the data with more rows. EDATE didn't work because I want the averages of the  "Ratio" measure. I added to the link the excel sheet with formulas so you can understand better what I am trying to do.

 

Thanks for any help.

 

Michelle

Please see the link for the Power BI and Excel sheet here Link