YTD Calculation is not working properly

[Anonymous]

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]))

[v-danhe-msft]

Hi @Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft]

Hi @Anonymous,

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

Regards,

Daniel He

[Anonymous]

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]))

[Sean]

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! 

[Sean]

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!