CALCULATE DISTINCT SUM FOR YTD

[ANM_97]

Hello!

I try to calculate the sum of the value at YTD, the total should be 1700 if we look at 2 months from 2021. In the first month we have 500, and in the second month 500 + 1200.
In the first month YTD = 500, in the second month YTD = 1700.

I have attached an example.
Using TOTALYTD (SUM (VALUE), DIM_DATE[DATE] ), the values ​​are added.
How can I achieve the expected result?

DATE	GROUP	VALUES	ACTUAL RESULT	EXPECTED RESULT
1/1/2021	A	500	500	500
1/2/2021	A	500	1000	500
1/3/2021	A	500	1500	500
1/4/2021	A	500	2000	500
1/5/2021	A	500	2500	500
1/6/2021	A	500	3000	500
1/7/2021	A	500	3500	500
1/8/2021	A	500	4000	500
1/9/2021	A	500	4500	500
1/10/2021	A	500	5000	500
1/11/2021	A	500	5500	500
1/12/2021	A	500	6000	500
1/13/2021	A	500	6500	500
1/14/2021	A	500	7000	500
1/15/2021	A	500	7500	500
1/16/2021	A	500	8000	500
1/17/2021	A	500	8500	500
1/18/2021	A	500	9000	500
1/19/2021	A	500	9500	500
1/20/2021	A	500	10000	500
1/21/2021	A	500	10500	500
1/22/2021	A	500	11000	500
1/23/2021	A	500	11500	500
1/24/2021	A	500	12000	500
1/25/2021	A	500	12500	500
1/26/2021	A	500	13000	500
1/27/2021	A	500	13500	500
1/28/2021	A	500	14000	500
1/29/2021	A	500	14500	500
1/30/2021	A	500	15000	500
1/31/2021	A	500	20000	500
2/1/2021	A	1200	21200	1700
2/2/2021	A	1200	22400	1700
2/3/2021	A	1200	23600	1700
2/4/2021	A	1200	24800	1700
2/5/2021	A	1200	26000	1700
2/6/2021	A	1200	27200	1700
2/7/2021	A	1200	28400	1700
2/8/2021	A	1200	29600	1700
2/9/2021	A	1200	30800	1700
2/10/2021	A	1200	32000	1700
2/11/2021	A	1200	33200	1700
2/12/2021	A	1200	34400	1700
2/13/2021	A	1200	35600	1700
2/14/2021	A	1200	36800	1700
2/15/2021	A	1200	38000	1700
2/16/2021	A	1200	39200	1700
2/17/2021	A	1200	40400	1700
2/18/2021	A	1200	41600	1700
2/19/2021	A	1200	42800	1700
2/20/2021	A	1200	44000	1700
2/21/2021	A	1200	45200	1700
2/22/2021	A	1200	46400	1700
2/23/2021	A	1200	47600	1700
2/24/2021	A	1200	48800	1700
2/25/2021	A	1200	50000	1700
2/26/2021	A	1200	51200	1700
2/27/2021	A	1200	52400	1700
2/28/2021	A	1200	53600	1700
TOTAL YTD	A	1700	55300	1700

Thank you~~!

[CNENFRNL · Accepted solution]

As to me, it's wierd to display results at MONTH level in a visual with granularity of DAY. Whatever, there're possible solutions.

[ANM_97]

@CNENFRNLIf I use the YTD formula on certain groups, how can I change the formula so that I see the total on that group, not the average?

[ANM_97]

Thank you so much!! ~~