topic Re: Average between Years in DAX Commands and Tips

Average between Years

Anonymous — Tue, 13 Sep 2022 21:46:08 GMT

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 I almost reached my target, but it's bringing an average between the 3 years and I need to do each year separated.

I've tryed a lot of manners to do it, but I couldn't find a solution yet. Please, if anyone have a tip or idea to solve it, would be great.

Best Regards

Clever

Re: Average between Years

amitchandak — Wed, 14 Sep 2022 03:00:26 GMT

Anonymous , You need to try a measure like

Rolling 3 = calculate(AverageX(Values('Date'[Year]),CALCULATE(sum(Sales[Sales Amount]))),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,Year))

replace sum sales amount with your measures , sum till year level and then avg.

Avg above month level

Rolling 3 = calculate(AverageX(Values('Date'[MONTH Year]),CALCULATE(sum(Sales[Sales Amount]))),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,Year))

Re: Average between Years

tamerj1 — Wed, 14 Sep 2022 06:07:12 GMT

Hi Anonymous

what exactly is your expected result?

Re: Average between Years

Anonymous — Wed, 14 Sep 2022 10:32:16 GMT

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.

Re: Average between Years

Anonymous — Wed, 14 Sep 2022 14:35:30 GMT

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

amitchandak

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

Re: Average between Years

tamerj1 — Wed, 14 Sep 2022 15:09:38 GMT

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] )
)

Re: Average between Years

Anonymous — Wed, 14 Sep 2022 17:04:50 GMT

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.

Re: Average between Years

tamerj1 — Wed, 14 Sep 2022 17:53:29 GMT

Anonymous

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

Re: Average between Years

Anonymous — Wed, 21 Sep 2022 23:47:59 GMT

Hi, good night, peace

I've tryed with Sum, but it's not working.
But thanks

Re: Average between Years

Anonymous — Wed, 21 Sep 2022 23:49:58 GMT

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

Re: Average between Years

tamerj1 — Thu, 22 Sep 2022 02:18:01 GMT

Anonymous

Yes 12:00-13:00 Dubai time

Re: Average between Years

Anonymous — Thu, 22 Sep 2022 12:29:13 GMT

Good Morning tamerj1

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

Best Regards.

Clever

Re: Average between Years

tamerj1 — Thu, 22 Sep 2022 12:59:57 GMT

tamer_juma@yahoo.com

Re: Average between Years

Anonymous — Thu, 22 Sep 2022 13:19:02 GMT

tamerj1 very nice.

I sent to you an invitation to tomorrow, at the time that you said.

Please, let me know If is a good time or If we need to re-schedule.

If you want, you can send me a new proposal.

Bye

Clever

Re: Average between Years

tamerj1 — Thu, 22 Sep 2022 13:45:34 GMT

Yes I saw it. It is ok with me

Re: Average between Years

Anonymous — Fri, 23 Sep 2022 12:16:19 GMT

tamerj1

First, I'm sorry for didn't get in.
If possible, could we schedule again? Maybe in another time?
I'm at Brazil Time.
Please, return me

Best Regards, Clever.

Re: Average between Years

tamerj1 — Fri, 23 Sep 2022 13:09:46 GMT

Today 6:00pm Dubai Time?

Re: Average between Years

Anonymous — Fri, 23 Sep 2022 14:02:06 GMT

So,

I just get in and I'm waiting for you right now.

Can you join with me?

Clever

Re: Average between Years

Anonymous — Fri, 23 Sep 2022 14:12:27 GMT

Brother,

Feel free to suggest another time so,

When you be avaiable for me it's going to be nice.
Tomorrow I'm free and on Monday onwards

So, When be a good time for you, I'll separate this time for sure.

Thanks for your disposition.

Clever