Turning year to date sum to year to date average

ashsandwich — Tue, 25 Jun 2024 20:58:50 GMT

Hi, I have a measure that sums the data year to date. I'm now looking to have an average year to date. This is my formula, is there anything I can do here to average instead of sum? Thanks very much.

YTD Sum = CALCULATE([Headcount Count Calc],DATESINPERIOD(data[Extract Date],max(data[Extract Date]), -12,MONTH))

Re: Turning year to date sum to year to date average

Anonymous — Wed, 26 Jun 2024 02:09:36 GMT

Hi ashsandwich ,

I think you can use AVERAGE function. Here is the changed DAX codes.

YTD Average = CALCULATE ( AVERAGE ( data[Headcount Count Calc] ), DATESYTD ( data[Extract Date] ) )

If you want to learn more about AVERAGE function. I think you can read this document: AVERAGE function (DAX) - DAX | Microsoft Learn

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: Turning year to date sum to year to date average in DAX Commands and Tips

Turning year to date sum to year to date average

Re: Turning year to date sum to year to date average