Forum Discussion
Average between Years
Hi @Cleverbro,
According to your description, you want to calculate the average between the years, right? Here are my steps you can follow as a solution.
(1)If you want to calculate the average by year, you can filter directly in the "Columns" section.
(2)Then the result is as follows.
If this method does not meet your needs, you can provide us with detailed input and output examples in tabular form so that we can better solve the problem for you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
I've tryed but this option don't shows to me.
tamerj1
Tamer, I'm doing a caculation in each line of my database,
so I want to bring a Avg Price Unit per Year Total like the colunm MD below and this be fixed like in the Formula MD in the 1ªScreenShot ,
But when I'm seing per month in the 2ªScreenshot, I've differents prices and they shoud be the same value as the 1ªScreenShot fixed (MD)
1ªScreenshot
But We can see that each month I've different's Price Unit
2ªScreenShot
The only point is that I'm using formulas to reach in my price unit, like below.
So when I try to use Sum, it's not allowed.
Do we have another Alternative?
Thanks
Clever
- tamerj1
Community Champion
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] )
)Hi tamerj1
I did it, but I think that didn't work well.
LookIf you have a time, we could make a quicky meet to see it, then we can apply your knowledge if necessary.
- tamerj1
Anonymous
We can do that tomorrow morning Dubai time. What is your time zone?
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
Anonymous
Yes 12:00-13:00 Dubai time
