Distribute Net Revenue between 2 columns using the date

Hi, HishamAT 

Based on the information you have provided, Here are my answers to your questions.

1. Generating a table with Year and Rev.

1. Create a Net Revenue, Rev and Measure to integrate them with the table above to get the results you want.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.