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
Community 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 

I did it, but I think that didn't work well. 
Look

If you have a time, we could make a quicky meet to see it, then we can apply your knowledge if necessary. 

 



  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    Anonymous 

    We can do that tomorrow morning Dubai time. What is your time zone?