cancel
Showing results for
Did you mean:
Helper III

## CALCULATE DISTINCT SUM FOR YTD

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~~!

1 ACCEPTED SOLUTION
Super User III

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

3 REPLIES 3
Super User III

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

Helper III

@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?

Helper III

Thank you so much!! ~~

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.