Distribute Net Revenue between 2 columns using the date

[HishamAT]

Hi

How can I create a table and distribute the Net Revenue between 2 columns using the date? for example :

Net Rev for the Year 2019 is 1000

Net Rev for the Year 2023 is 2000 

this should be like this table  : 

Year	NetRev19	NetRev23
2019	1000	0
2023	0	2000

[v-yilong-msft]

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.

[ryan_mayu]

@HishamAT 

maybe you can try to create two measures

2019value = CALCULATE(sum('Table'[value]),FILTER('Table','Table'[year]=2019))

2023value = CALCULATE(sum('Table'[value]),FILTER('Table','Table'[year]=2023))

[Ahmedx · Accepted solution]

pls try htis