cancel
Showing results for
Did you mean:
Frequent Visitor

## YTD Calculation is not working properly

Hi,

I have created a YTD measure using the below formula. But when I put them in the grid. Its showing the same result for Splitter Amount as well as for the Amount YTD. Could you please help me here throwing some lights on what would have gone wrong?

Amount YTD = CALCULATE(('Sales'[Splitter Amount]), DATESYTD('Calendar'[CLDR_DT]))

5 REPLIES 5
Frequent Visitor

## YTD calculation is not working as expected

Hi,

I have created a YTD measure using the below formula. But when I put them in the grid. Its showing the same result for Splitter Amount as well as for the Amount YTD. Could you please help me here throwing some lights on what would have gone wrong?

Amount YTD = CALCULATE(('Sales'[Splitter Amount]), DATESYTD('Calendar'[CLDR_DT]))

Super User

## Re: YTD Calculation is not working properly

This is what your basic YTD Measure should look like.

```YTD Measure =
CALCULATE (
[measure],
DATESYTD ( 'Date'[Date] )
)```

It seems you are referencing a naked column. So just add the appropriate aggregation function.

```Amount YTD =
CALCULATE (     SUM ( 'Sales'[Splitter Amount] ),    DATESYTD ( 'Calendar'[CLDR_DT] ))```

Hope this helps!

Super User

## Re: YTD calculation is not working as expected

This is what your basic YTD Measure should look like.

```YTD Measure =
CALCULATE (
[measure],
DATESYTD ( 'Date'[Date] )
)```

It seems you are referencing a naked column. So just add the appropriate aggregation function.

```Amount YTD =
CALCULATE (     SUM ( 'Sales'[Splitter Amount] ),    DATESYTD ( 'Calendar'[CLDR_DT] ))```

Hope this helps!

Community Support Team

## Re: YTD Calculation is not working properly

Could you please post me some sample data and your desired result?

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team