Forum Discussion

SimonSeez's avatar
SimonSeez
Helper III
5 years ago

DatesAdd Function with Custom Date - Help Needed

Hello,  I am using this custom date table and I need to perform some MTD, QTD and YTD calculations. I am using DatesADD function and it just does not seem to work. The result always gives the sum of...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • SimonSeez's avatar
    SimonSeez
    Helper III
    5 years ago

    Hello Pat, 

     

    I am using this 

     

    Calculate([Total Revenue], DateAdd('Date Table' [Date], -1, Quarter))

     

    Rather than give me total for the last quarter, it gives a total for the whole of the previous year