Forum Discussion

petermb72's avatar
petermb72
Icon for Helper IV rankHelper IV
6 years ago

TotalYTD is returning Monthly total

Facts:  We run on a Fiscal Year October 1 to September 30.  I have a date table that has a date for every day that goes from 10/1/2014 to 9/30/2030.   I have a calculated Montly total The main t...
Need Help
petermb72's avatar
petermb72
Icon for Helper IV rankHelper IV
6 years ago

I used the following formula:

 

Total YTD3 = TOTALYTD(SUM(AccountSummary[Total]),Dates[Date],ALL(Dates),"9/30")
 
It returned the monthly total for each month of the year, not the YTD.  date table
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi petermb72 ,

 

Year and Period ID must be part of your date table.

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.