Calculation per Year

[Anonymous]

Hello,

I am looking for a measure that calculate the revenue per year. What I have for the moment is this

The column Year is a measure (don't know if it is the right thing to do)

The formula of the measure is the following

I am calculating the difference between the service date and the scheduled date in months. So the first 12 months are "Year 1" from 12 to 24 are "Year 2" and so on.

But I want to have the view, revenue per year. But when I take out all the unnessesary columns I have the following

The result I am looking for is the following

Can someone help me please?

Thanks

[amitchandak]

@Anonymous , Not very clear, what are you trying to achieve?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Hello,

Thank you for helping me. You will find the database in the following link https://we.tl/t-GtgGForBuJ. The 2 last columns are formulas that I need in power bi

The result is the following I want

Thanks for your help