Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Average between Years

Hi Guys, peace.    I have a situation that I don't know how to solve.    So, I need to calculate the average between the years and bring this information fixed as a example below, in column MD LY...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 

Seems you have multiple queries. Let start with this

Price Unit EUR =
CALCULATE (
DIVIDE ( [Total Costs EUR], [Volume Total KG] ),
ALLEXCEPT ( 'Date', 'Date'[Year] )
)

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi tamerj1  , peace


So I did some tryes here, but nothing worked well. 
So could we make this meet? When are you available? Friday (23/09) looks good to you? 

 

Best Regards. 

Clever

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Anonymous 

    Yes 12:00-13:00 Dubai time

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Good Morning tamerj1 

       

      Nice, let's schedule it. 
      Could you please inform your e-mail. I'll send you an invitation. 

      Best Regards. 

      Clever