Forum Discussion
Error in YTD Calc
- 8 years ago
Hi AustralPRB,
The root cause is no data of "Sundry Income" of June exists. The possible solution could be like below.
GL YTD = CALCULATE ( TOTALYTD ( [GL Actual], dDate[Date] ), ALL ( dDate[Month] ) )
Best Regards,
Dale
Hi mnayar
Thanks for your prompt response, will try and give more detail this time.
I have a Report that shows the GL Actual and GL YTD in separate columns. I have 4 slices YEAR Month Branch and Service.
The report should be Filtered by Year and Month to Give a Month to Date / Year to date Figure in the 2 Columns Which it does. and corresponds to the Accounting system.
When the other 2 Slices are used it should allow filtering by Branch and Service, which it does for the totals but as shown by the example the YTD is not calculating for certain lines.
Pic1 Shows the January Report for Branch 20 Service 60 and is correct

Pic2 Shows the June report with the correct total but the line for Sundry Income 1363.64 should appear in the YTD Column

GL Actual
GL Actual = IF(min(GLEntries[Group Name]) ="Income",SUMX(GLEntries,GLEntries[IncomeCalc])+0,SUMX(GLEntries,GLEntries[GL Amount])+0)
GL YTD
GL YTD = TOTALYTD([GLYTD],DATESYTD(dDate[Date]),"30/06")+0
Looking at this I suspect the YTD formula needs changing, Have tried the ALL() with no difference ?
Pic1Pic2
- v-jiascu-msft8 years ago
Microsoft Employee
Hi AustralPRB,
Can you share the file? You can delete or mask the sensitive parts.
Best Regards,
Dale
- AustralPRB8 years agoFrequent Visitor
I can send you pbix file