create table with series of costs by month

[jppuam]

[amitchandak]

@jppuam , Create a table using generateseries

months= generateseries(1,120,1) 

new table=Filter(generate(months,table), month[value]<= Table[Month])

Add columns with divided values with no of month

Same example with dates

How to divide/distribute values between start date or end date or count days across months/days: https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...

[jppuam]

hello amitchandak,

i dont quite understand.  I dont have dates, can you explain again pls ?

see this example:

ProductCode      monthsContract      value

Z0001                   25                         1000

Z0002                   36                         1550

Z0003                   48                         1800

i want to generate the month value per product, but the product Z0001 only goes to the month 25, and the second to month 36 and so one. can you see it please ?

thanks,

JR

thanks,

JR

[v-shex-msft]

HI @jppuam,

Did the value field mean the cumulative value between different records?

If that is the case, you can get the total value based on the current and previous values. Then you can calculate it with the month number diff to get the monthly value.

If not, did these values mean the month value from the current one till the new month value? (e.g. month 25~35: 1000, month 36~47:1550)

For this scenario, you can try to create a new table with all month numbers and 'product code' then look up the last record with value to fill up the records without values.

Regards,

Xiaoxin Sheng

[jppuam · Accepted solution]

Hello,

i've manage to figure out meanwhile out to do.

Thanks for the help,

JR