Forum Discussion
MTD calculation values not coming correctly
Hi,
I am facing a simple problem (probably) which I am unable to resolve.
Problem is while computing the MTD values totals are matching. Below is the screen shot.
Formula : MTD = TOTALMTD(SUM(COMM_YTD[CALC_RET_COMM]),DATESMTD('Calendar'[DateKey].[Date]))
The same method I have used earlier which is working perfectly this time I don't know what happened.
Please help me on this.
4 Replies
- anupampandeyHelper III
Hi,
I am facing a simple problem (probably) which I am unable to resolve.
Problem is while computing the MTD values totals are matching. Below is the screen shot.
Formula : MTD = TOTALMTD(SUM(COMM_YTD[CALC_RET_COMM]),DATESMTD('Calendar'[DateKey].[Date]))
The same method I have used earlier which is working perfectly this time I don't know what happened.
Please help me on this.
- mattbriceSolution Sage
My only comment is that using both TOTALMTD and DATESMTD is redundant. Should either do:
MTD = TOTALMTD(SUM(COMM_YTD[CALC_RET_COMM]), Calendar[Date] )
or
MTD = CALCULATE( SUM(COMM_YTD[CALC_RET_COMM]), DATESMTD (Calendar[Date] ) )
- anupampandeyHelper IIIHi, I have used what you suggested still not getting the desired result. Thanks, Anupam
- Phil_SeamarkMicrosoft Employee
Hi mattbrice
This PBIX file has two versions of the formula that work.
Download and have a play to see if it helps.
Cheers,