https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-with-monthly-budget-value-in-the-future-based-on-each-month/m-p/3438121#M130472 <P>Video helps very good, just made some modifications. Thank you!</P> Tue, 19 Sep 2023 10:54:39 GMT Anonymous 2023-09-19T10:54:39Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-with-monthly-budget-value-in-the-future-based-on-each-month/m-p/3428104#M129948 <P>Dear all,</P><P>&nbsp;</P><P>please find enclose an example for a PBI Report incl. a VDIM_Calendar and a vfakt table.</P><P>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.<BR />In the end, in the PBI report, I need a stacking column graph that stacks the budget monthly values of each project.<BR />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).</P><P>Maybe it will be easier to understand if you look at the report and the Excel sheet with the result.</P><P>Thank you for your help in advance!</P><P>KR</P><P>Maha</P><P>&nbsp;</P><P>I hope I can share the pbi file and the xls file with these links.</P><P>PBI File&nbsp;</P><P><A href="https://app.powerbi.com/groups/me/reports/31a5ba69-5fa0-45f9-8fa5-714497958b8d?ctid=45de56ea-e505-43a5-bd60-4957c8afc438&amp;pbi_source=linkShare" target="_blank">https://app.powerbi.com/groups/me/reports/31a5ba69-5fa0-45f9-8fa5-714497958b8d?ctid=45de56ea-e505-43...</A></P><P>&nbsp;</P><P>xls File with solution in Excel</P><P><A href="https://app.powerbi.com/groups/me/workbooks/1_69169_3000654?experience=power-bi" target="_blank">https://app.powerbi.com/groups/me/workbooks/1_69169_3000654?experience=power-bi</A></P><P>&nbsp;</P><P>PBI screenshot VFAKT and calendar VDIM</P><P>&nbsp;</P><P><img /></P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>Excel screenshot</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Wed, 13 Sep 2023 08:55:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-with-monthly-budget-value-in-the-future-based-on-each-month/m-p/3428104#M129948 Anonymous 2023-09-13T08:55:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-with-monthly-budget-value-in-the-future-based-on-each-month/m-p/3428248#M129953 <P>Based on what I got the following video will be helpful -</P><P><SPAN><SPAN class="">Measure way<BR />Power BI Dax Measure- Allocate data between Range: <A title="https://youtu.be/o653vwltuzm" href="https://youtu.be/O653vwLTUzM" target="_blank" rel="noreferrer noopener">https://youtu.be/O653vwLTUzM</A></SPAN></SPAN></P> Wed, 13 Sep 2023 10:11:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-with-monthly-budget-value-in-the-future-based-on-each-month/m-p/3428248#M129953 nirali_arora 2023-09-13T10:11:21Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-with-monthly-budget-value-in-the-future-based-on-each-month/m-p/3438121#M130472 <P>Video helps very good, just made some modifications. Thank you!</P> Tue, 19 Sep 2023 10:54:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax-with-monthly-budget-value-in-the-future-based-on-each-month/m-p/3438121#M130472 Anonymous 2023-09-19T10:54:39Z