https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distribution-Help/m-p/1698640#M34965 <P>Hi everyone,</P><P>&nbsp;</P><P>Hoping you can assist with this distribution, i'll do my best to explain.&nbsp;</P><P>&nbsp;</P><P>I'd like to distribute cost by month in such a way where it's cumulative(?) on the graph until the cost reaches it's end date, essentially ignoring the start date. When the end date is reached, the cost drops off.</P><P>&nbsp;</P><P>For example, Jan 2018 would have $16,000 in cost (sum of project costs for all projects) and Mar 2021 would have $15,000 in cost (sum of project costs minus project A, since the end date has passed (1/30/2021).</P><P>&nbsp;</P><P>Below is the table and I have a date table as well.</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><img /></P><P>&nbsp;</P><P>Thank you in advance.</P> Tue, 02 Mar 2021 13:37:22 GMT peterso 2021-03-02T13:37:22Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distribution-Help/m-p/1698640#M34965 <P>Hi everyone,</P><P>&nbsp;</P><P>Hoping you can assist with this distribution, i'll do my best to explain.&nbsp;</P><P>&nbsp;</P><P>I'd like to distribute cost by month in such a way where it's cumulative(?) on the graph until the cost reaches it's end date, essentially ignoring the start date. When the end date is reached, the cost drops off.</P><P>&nbsp;</P><P>For example, Jan 2018 would have $16,000 in cost (sum of project costs for all projects) and Mar 2021 would have $15,000 in cost (sum of project costs minus project A, since the end date has passed (1/30/2021).</P><P>&nbsp;</P><P>Below is the table and I have a date table as well.</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><img /></P><P>&nbsp;</P><P>Thank you in advance.</P> Tue, 02 Mar 2021 13:37:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distribution-Help/m-p/1698640#M34965 peterso 2021-03-02T13:37:22Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distribution-Help/m-p/1698725#M34974 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="243549" data-lia-user-login="peterso" class="lia-mention lia-mention-user">peterso</a> , Not getting your number. Check Page 2 and table 3</P> Tue, 02 Mar 2021 14:17:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Distribution-Help/m-p/1698725#M34974 amitchandak 2021-03-02T14:17:50Z