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?

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi lnjwilliamson86

 

Your code works fine for me.  Have you created it as a calculated measure and do you have a relationship between your Datasheet table and your Date table?

 

lnjwilliamson86's avatar
lnjwilliamson86
Frequent Visitor
8 years ago

Hi Phil_Seamark

 

Thank you for replying so quickly!

 

I have a many to one with a single cross filter direction relationship between my datasheet table and date table.

 

I created it as a new column and i halso tried as a new meaure and neither seems to be working.

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    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?