Dax with monthly budgetvalue 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!

[Anonymous]

Hi, 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

Excel screenshot

[Anonymous]

Hi @Anonymous,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

If you do not have permission to upload your content to forum, you can upload to the net drive and create a share link to paste here. (notice: please not attach sensitive contents in it)

Regards,

Xiaoxin Sheng

[Anonymous]

How can I enter an example with the pbix file and a xls file?

[Anonymous]

Hi @Anonymous,

Any update on this? It is hard to test without any detail information and sample. If you not have permissions to attach these to your thread, you can upload to network driver and share the link here.

Regards,
Xiaoxin Sheng

[Anonymous]

Hi Community Support, I was unplanned not available the last weeks. I still need your support. But since I can't upload the test file here, I'll try the way over the network drive and share the link. I'll get back to you asap, because I need our IT to do this.

Regards

Maha