Equally distribute some value over periods

[Anonymous]

Hi there,

I am having issues in producing a line diagram that cumulatively distributes some value over periods in a linear way.

Period	Value
1	1000
1	2000
2	2200
3	200
4	900
5	-500
5	-1000
6	-200
7	-800
8	-800
9	1000
10	2000
11	2000
12	1000
12	9000

I am using Measure1 = SUM(Table1[Value])/12 that results in 18000/12=1500. Next, I am trying to create a line diagram that cumulates 1500 over 12 periods (1500, 3000, 4500, ..., 18000) using a second measure. I cannot add additional tables or columns to the data.

Do you have any idea?

Thank you so much!

[amitchandak]

@Anonymous , better to distribute value -

https://www.dropbox.com/s/fnq82ksdzk1lqs3/Target_allocation_daily.pbix?dl=0

[Anonymous]

Hi, somehow I cannot open your PBIX. Can you explain?

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

Create a measure as below:

Measure2 = CALCULATE(SUM('Table'[Value])/12,FILTER(ALL('Table'),'Table'[Period]<=MAX('Table'[Period])))

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!