Budget dididing over working days and using afterwards in a cumulative context.

[PeterVanDenBosc]

I have a date table which has a colom which gives a value "True" if it is a working day and "False" if not. On the other hand i have a data table which contains a monthly budget per product perCustomer. It always gives as date of budget eg "jan 2023". As this file is exported from our server and as i am importing it, it puts the monthly budget always on the first of the month. What i want to achieve is a measure which calculates the budget for every day in a cumulative way, so i can put it afterwords in a visual which projects the budget cumulative versus teh sale cumulatively. The sale is ok but i can't get it wright with the budget. Can somebody help me with this?

thx

Peter

[technolog]

I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.

Your insights and updates will greatly assist others who might be encountering the same challenge.

[some_bih]

Hi @PeterVanDenBosc link below could be useful for you at least as idea; forecast is same as budget for your purpose. For part to calculate cumulative... if you have item level data, like sales per item sold with date of transaction, so literally daily than you use simple SUM (Your table[columnname]) as measure, otherwise think about same level of granularity when you compare actual vs budge. Hope this help / kudos appreciated.

https://www.sqlbi.com/articles/showing-actuals-and-forecasts-in-the-same-chart-with-power-bi/