Distribue Value Within the Month

[sekinod]

I have following data table which contains only value for each month end.

 

I want to create calculated columns for date table which contain distributed value within the month as per the product. Distribution for the date must be calculated by (number of working days up to date/total no of working days in the month).

My date table as follows.

after the calculation, four columns should be there for the respective product and value for each date.

Download Sample Data

Much appreciated your help.  

[daxer-almighty]

Such calculations should be done in Power Query, not in DAX.