how to fix the calculated budget

[PBI_newuser]

Hi, I have FY18 to FY21 data. I wanna set FY19 actuals as budget for FY20, FY21 and FY22. I have created below measure but it doesn't appear in other months except for the months in FY19. Besides, the budget for each month should be the same but it shows different value in each month.

Budget = CALCULATE(DIVIDE(SUM(Table[Cost]),12),FILTER('Calendar','Calendar'[Fiscal Year]="FY2019"))

[ryan_mayu · Accepted solution]

@PBI_newuser 

pls see the attachment below

[PBI_newuser]

Hi @ryan_mayu , is it possible to calculate the cumulative sum for budget? 

For example, in your pbix file, the budget for each month is 650, I would like to see first month = 650, second month = 1300, third month = 1950 and so on.

[ryan_mayu]

@PBI_newuser 

maybe you can try this

measure = if(left(max('Table (2)'[yearmonth]),4)="2019",blank(),DIVIDE(CALCULATE(sum('Table (2)'[value]),FILTER( all('Table (2)'),year('Table (2)'[date])=2019)),12))*(datediff(CALCULATE(min('Table (2)'[date]),all('Table (2)')),max('Table (2)'[date]),MONTH)-11)

pls see the attachment below

[PBI_newuser]

Hi @ryan_mayu, how to make the cumulative start from 650 when the date range is selected?

[ryan_mayu]

@PBI_newuser 

pls see the attachment below.