topic Average by quarter in DAX Commands and Tips

Average by quarter

Anonymous — Mon, 15 May 2023 09:17:40 GMT

Hi,

in Power BI I need to calculate an average of values by quarter (I have the column for quarter numbers). So I need to take the values for each quarter and calculate an average for these.

Example of what I need:

value	quarter	avgByQuarter
0.5	1	0.75
1	1	0.75
-2	2	-2
0	2	-2
-1	3	-0.25
0.5	3	-0.25

Thank you so much for the help!

Re: Average by quarter

NikhilChenna — Mon, 15 May 2023 09:36:11 GMT

Hi Anonymous ,

I think below can solve your issue, create a measure of Avg as below ,

Avg = AVERAGE(table1'[value])

And then drag this in your table and check if it works.

Regards,
Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

Re: Average by quarter

tamerj1 — Mon, 15 May 2023 10:08:59 GMT

Hi Anonymous
Are all columns coming from the same table or do you have a data model with multiple tables? Are lookig for a calculated column or a measure?