Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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 her...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
Sean
Icon for Community Champion rankCommunity Champion
8 years ago

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! Smiley Happy