Forum Discussion

lnjwilliamson86's avatar
lnjwilliamson86
Frequent Visitor
8 years ago
Solved

YTD Function Help

Hi,    I am trying to perform a simple TOTALYTD function and have used to add up the number of applications recevied in a fiscal year.  I added a column with the formula :   FYTD Leak Remission ...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Ensure that the date you drag from into your visual is from the Date Table.  Also does this work?

     

    =CALCULATE(SUM(Datasheet[1. Leak remission applications approved]),DATESYTD('Date'[Date],"6/30"))

    Does it work if you change the input to "30/6"?

  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    did you try Ashish_Mathur suggestion about making sure you use the date field from your date table on the axis of your visual?

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Ensure that the date you drag from into your visual is from the Date Table.  Also does this work?

 

=CALCULATE(SUM(Datasheet[1. Leak remission applications approved]),DATESYTD('Date'[Date],"6/30"))

Does it work if you change the input to "30/6"?