Spread value over time based on percentage

[Skruff]

I want to calculate the future revenue/value of a total based on percentages in a different table. I want to be able to use this with a date reference for visualization as well.

In table A i have two columns, Project Name and Total Sales. In table B i have Project Name, January %, February % and so on. This table has the estimated percentage of completion of the projects for the next three years (monthly).

I want to calculate the Total Sales on a monthly basis going forward but have this attached to a time line. If it helps i have date table as well. Would this have to be a new table all together? 

[v-yuezhe-msft]

@Skruff,

Please share dummy data of table A and B and post expected result based on the dummy data. We also need to know the relationship between table A and B.

Regards,
Lydia

[Skruff]

See attached the simple example. Basically the percantages in table B are multiplied with the total sales in table A. 

[v-yuezhe-msft · Accepted solution]

@Skruff,

Please check the following PBIX file.

https://1drv.ms/u/s!AhsotbnGu1NolAR_A7-AAWqbRVvJ

Regards,
Lydia

[kbuckvol]

Hi, I have a problem similar to the OPs and think your solution might help me but it appears that it is no longer available.  Could you share how you solved the problem?

[Skruff]

Thank you, much appreciated.