Cumulative Budget Allocation Formula With Mismatched Granularities

Hi Anonymous , 

According to your description, you want to You want to accumulate calculations [Budget]. Here are my steps you can follow as a solution. 

(1)My test data comes from the example data you provided in the previous post. Re: Nonlinear Budget Release Measure - Microsoft Power BI Community 

(2)We can create a measure.  

BudgetAllocation =  

var _slice=SELECTEDVALUE('Dates'[DateKey]) 

var _table=FILTER(ALL('Budget Table'),'Budget Table'[DateKey] <= _slice) 

return 

SUMX(_table,'Budget Table'[Budget ]) 

(3)Then the result is as follows. 

If this method does not meet your needs, you can provide us with detailed input and output examples in tabular form so that we can better solve the problem for you. 

Best Regards, 

Neeko Tang 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.