Projection of quantities by month

[mraka9]

I have a table with the following items: Item number, group, item, quantity, contract duration from:, contract duration to:

I want to create a quantity projection for each month from the start of the contract duration to the end of the contract duration, only for working days.

With the condition that the starting month is calculated from the contract start date in that month and also up to the end date of the final month.

I am providing an example of the initial table and the desired display.

 

 Thank you and best regards

[lbendlin]

What is your definition of "working days" ?  You need to provide details of your weekends and holidays. There is a NETWORKDAYS() function if you want.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[mraka9]

I found a solution using chatgpt. Thanks