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
mluanacruz's avatar
mluanacruz
Icon for Helper I rankHelper I
4 years ago

Thanks for the feedback. I updated the request with a sample of my data! Hope someone can help me.

  • 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