cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hariprasadpargu Frequent Visitor
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
hariprasadpargu Frequent Visitor
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
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! Smiley Happy

 

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

Community Support Team
Community Support Team

Re: YTD Calculation is not working properly

Hi @hariprasadpargu,

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
Community Support Team

Re: YTD Calculation is not working properly

Hi @hariprasadpargu,

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

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.