Monthly calculation given Start Date, Duration, Total Value and Customer Name

[Spen]

Hi All,

Can anyone help.

I have a [Start Date], [Duration Months], [Total Value] and [Customer Name]

What I want to do is show for every month the total value for each customer.

ie

The data table i want to see is :

And a Matrix as :

Any help greatly appreciate.

💪📊

[amitchandak · Accepted solution]

@Spen , Create a new calculated table and use that

Addcolumns(filter(generate(Table, generateseries(0,20,1)), [Value] < [Duration]), "_month", eomonth([Start Date], [Value] -1)+1)

[Spen]

Amazing. Thank You 💪