Dax with monthly budget value in the future based on each month in a graph

[Anonymous]

Dear all,

please find enclose an example for a PBI Report incl. a VDIM_Calendar and a vfakt table.

In the xls file, I have highlighted in light blue the basic information that is available to me according to vfakt. The orange columns I have added in the vfakt by calculation. Now I am missing the information of the green fields in the Power Bi Report.
In the end, in the PBI report, I need a stacking column graph that stacks the budget monthly values of each project.
The monthly values are always assigned to the last day of the month, i.e. in the start date is the start month and the year, the runtime is the number of months related to the runtime (years). The end date contains the last month at the end of the runtime (months).

Maybe it will be easier to understand if you look at the report and the Excel sheet with the result.

Thank you for your help in advance!

KR

Maha

I hope I can share the pbi file and the xls file with these links.

PBI File 

https://app.powerbi.com/groups/me/reports/31a5ba69-5fa0-45f9-8fa5-714497958b8d?ctid=45de56ea-e505-43...

xls File with solution in Excel

https://app.powerbi.com/groups/me/workbooks/1_69169_3000654?experience=power-bi

PBI screenshot VFAKT and calendar VDIM

Excel screenshot

[nirali_arora · Accepted solution]

Based on what I got the following video will be helpful -

Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

[Anonymous · Accepted solution]

Video helps very good, just made some modifications. Thank you!

[nirali_arora · Accepted solution]

Based on what I got the following video will be helpful -

Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM