topic Re: Dax with monthly budgetvalue in the future based on each month in a graph in DAX Commands and Tips

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

Anonymous — Thu, 10 Aug 2023 11:26:56 GMT

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!

Re: Dax with monthly budgetvalue in the future based on each month in a graph

Anonymous — Thu, 10 Aug 2023 11:25:01 GMT

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

Re: Dax with monthly budgetvalue in the future based on each month in a graph

Anonymous — Mon, 14 Aug 2023 01:48:30 GMT

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

Re: Dax with monthly budgetvalue in the future based on each month in a graph

Anonymous — Fri, 25 Aug 2023 08:13:24 GMT

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

Re: Dax with monthly budgetvalue in the future based on each month in a graph

Anonymous — Thu, 07 Sep 2023 08:09:32 GMT

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

Re: Dax with monthly budgetvalue in the future based on each month in a graph

Anonymous — Mon, 11 Sep 2023 09:28:50 GMT

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-43a5-bd60-4957c8afc438&pbi_source=linkShare

xls File with solution in Excel

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

PBI screenshot vfakt

Excel screenshot