Total Cumul Outstanding Dax

[majid_75]

Hi,

I have a table wiht data Outstanding:

Date	Code Trade	Outstanding	Result : Cumul
01/01/2022	A	500	650
02/01/2022	A	500	650
03/01/2022	A	500	650
04/01/2022	A	500	650
05/01/2022	A	500	550
01/01/2022	B	50	650
02/01/2022	B	50	650
03/01/2022	B	50	650
04/01/2022	B	50	650
05/01/2022	B	50	550
01/01/2022	C	100	650
02/01/2022	C	100	650
03/01/2022	C	100	650
04/01/2022	C	100	650

I try to create a measure that allows to accumulate the outstanding over 5 years in daily (like in the column "Result:Cumul").

An idea pls?

Thnks

[v-jianboli-msft · Accepted solution]

Hi @majid_75 ,

Please try:

Result:Cuml = CALCULATE(SUM('Table'[Outstanding]),FILTER(ALL('Table'),[Date]=MAX([Date])))

Output:

Besides, it seems that you want accumulate the outstanding over 5 years in daily, the result is different from Result:Cumul. If you want accumulate the outstanding over 5 years in daily, please try:

Over 5 Years = CALCULATE(SUM('Table'[Outstanding]),FILTER(ALL('Table'),[Date]<=MAX('Table'[Date])&&[Date]>=EDATE(MAX('Table'[Date]),-60)))

Output:

Best Regards,

Jianbo Li

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

[majid_75]

For exemple, the 01/01/2022 is A + B +C = 650, etc... the 05/01/2022 is A+B=550

[lbendlin]

You don't need any DAX for that. Power BI offers automatic aggregation.

see attached.

[majid_75]

I try to create a measure that allows me to cumulate the Outstanding according to the code.

I try to create a measure that allows me to cumulate the Outstanding according to the code.
The result I want is the Result column

Thks

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?