Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Need help With YTD

Hi All,

 

I have tried different solutions for YTD formulas from this forum for my work but none seems to work. I suspect it my be due to the specific nature of the SQL(Directquery) I am using. See a screenshot:

 
 
 
Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      HI Anonymous ,

      I'd like to suggest you use the date function to manually defined filter range, time intelligence functions seem not fully works on live mode.

      Time Intelligence "The Hard Way" (TITHW)  
      Regards,

      Xiaoxin Sheng

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Anonymous , Can you explain a little further on what you described as the filtered range. I have tried using the suggested formula but to no avail. I created a formula that converted YES to 1 and NO to 0 ,based on which I calculated the value for summing up the YTD but still not working for me.

         

        Any Ideas??