Forum Discussion

New Member

4 years ago

Solved

Help

Hi all, i want to caculate cumulative average of column "Tổng nhân sự". I used dax: CALCULATE(SUM('NSLĐ'[Tổng nhân sự]),DATESYTD('NSLĐ'[Date])) But results returned is current value of column "Tổ...

Need Help

ALLUREAN
4 years ago
Hi, thanhnt2

I tried using measures to achieve what you want.
https://www.dropbox.com/s/ab6vpfzxjk2819l/Average_YTD%28allure-analytics.com%29.pbix?dl=0

ALLUREAN

Solution Sage

4 years ago

Hi, thanhnt2

CALCULATE(AVERAGE('NSLĐ'[Tổng nhân sự]),

ALL('NSLĐ'),'NSLĐ'[Date]<=EARLIER('NSLĐ'[Date]))

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

thanhnt2

New Member

4 years ago

Hi Allurenan

I try use your dax, but value need to break when pass the year.

your dax, sum all value in column.