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 amitchandak  

     Yes, I am using a date table. Off to watch your video now 

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      SimonSeez , in case that does not help. Also, the useful information provided by other super users/users does not help. then

      Please share a sample pbix after removing sensitive data.

      • SimonSeez's avatar
        SimonSeez
        Helper III
        5 years ago

        Hello amitchandak 

         

        Educative video as expected. I subscribed to the channel as well. I have applied everything you said and I noticed you used a DatesYTD before you used the DatesAdd. I hadn't seen this used before so I tried it 

         

        This was my previous measure - 

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

         

        I modified it to seem like yours 

        Calculate([Total Revenue], DatesQTD(DateAdd('Date Table' [Date], -1, Quarter))). Strangely this gave me a blank result 

         

        I then remodified to this 

        Calculate([Total Revenue], DatesQTD(DateAdd('Date Table' [Date], -1, Year))) and strangely it gave me the correct result. I couldn't make sense of my the measure worked so I have some doubts. 

         

        Any ideas why?