Cumulative budget dynamic variable

Power Query Data Setup
1

Hi
I have been studying your video → https://www.youtube.com/watch?v=qlBtBme4EL4

I have created a basic cumulative budget model and visual.

The daily budget value is static and is captured in a measure, value is $1500
This measure is used in the cumulative budget 2 measure.
I would like the daily budget to be a dynamic value based on the daily income measure in my measures table.
How do I set up the model so that I can pass the daily income value into the cumulative budget 2 measure?
thanks
Template 25.05.22.pbix (232.3 KB)

1 Like
3

Hi @jsavage - Please check attached file. It passes [DailyBudget] into [ cumulative budget 2] measure.

Template 25.05.22.pbix (198.6 KB)

Thanks
Ankit J

4

Hi @jsavage, have you checked the file provided by @ankit? Did it help in your query?

5

Hello @jsavage, just following up if the response above help you solve your inquiry?

We’ve noticed that no response has been received from you since a few days ago. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

1 Like
6

Hi @jsavage, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

7

thanks this is great