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

So you need to have matching fields in the date calendar as well?? Now that is something that is not in the instructions that I have read.  I will give that a try.

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional
    6 years ago

    Hi petermb72 ,

     

    YTD aggregates over the date table, so this field must be part of the date table. Otherwise it will slice the data by this fields.

     

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

    Please give Kudos for support.

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi petermb72 ,

     

    How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


    Best regards,