Calculate Values Seperately For Each Year

[mehmet_93]

Hi guys,

I have values for 2019,2020,2021 and 2022 years. I want to calculate monthly and cumulative average for per year but the years are seperately each other. Is there a Dax formula for this? In a one table, I wanna calculate just 2019 or 2020 or 2021 or 2022. For cumulative, I have tried following formula but when i filter with year, It doesn't calculate just the filtered year, It only shows values of filtered yar.

Kümülatif Setup Hariç Ortalama Üretim Adeti = CALCULATE(AVERAGE('2022 H4'[Üretim Adeti]),FILTER(ALL('2022 H4'),'2022 H4'[TARİH] <= MAX('2022 H4'[TARİH])),'2022 H4'[SETUP] <> "S")

Thank you.

[mehmet_93 · Accepted solution]

Hi guys, I have just changed ALL() function to ALLSELECTED() function, and it's worked.

Kümülatif Setup Hariç Ortalama Üretim Adeti = CALCULATE(AVERAGE('2022 H4'[Üretim Adeti]),FILTER(ALLSELECTED('2022 H4'),'2022 H4'[TARİH] <= MAX('2022 H4'[TARİH])),'2022 H4'[SETUP] <> "S")

[Syk]

You can use the DatesBetween function to get the a specific year, for example this would return only 2019 (copied from your formula)

Kümülatif Setup Hariç Ortalama Üretim Adeti = CALCULATE(AVERAGE('2022 H4'[Üretim Adeti]),DatesBetween(Table[Date],"1/1/2019","12/31/2019"))

[mehmet_93]

I have tried as your suggestion. But in graph, it shows values month by month. I wanna show values cumulative month by month with another line. What kind of DAX formula would I use?