Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculation per Year

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

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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