Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Insurance Triangulations

Hello,   I require a DAX formula to split a total amount depending on when the month of the amount.  I have put a table to show this below. For example if I have £100,000 in January I need this spl...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks lbendlin  The 100,000 figure was just an example purposes and would be different for each month would it possible to have this figure different for each month?

     

    Thanks

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Please provide sample data that fully covers your issue.
      Please show the expected outcome based on the sample data you provided.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Very close to the solution you provided, however I want the amount that needs to be split by month based off column B which is the "GWP" amount for that specific month.

         

        Hope that makes more sense. Thanks