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 split out by 24 months (each amount for the month will be £4,167)
or in December the total is £50,000 I need this amount split by 13 months therefore £3,846 monthly.

 

 January 24
 February 23
 March 22
 April 21
 May 20
 June 19
 July 18
 August 17
 September 16
 October 15
 November 14
 December 13

 

In theory I want to replicate the table shown below and need to total the columns together.

 

 

 

Need Help

8 Replies

    • 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.