Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

YTD calculation

  How do I calculate the revenue YTD?   I used:  YTD 2019 = calculate(sum('invoices'[Amount]);DATESYTD('invoices'[Posting_Date]))   But it does not work. I also want to use SamePeriodeLastYear...
Need Help
  • vanessafvg's avatar
    vanessafvg
    7 years ago

    Anonymous  you need to have a date table for date functions, have you got a separate date table?

vanessafvg's avatar
vanessafvg
Community Champion
7 years ago

Anonymous  you need to have a date table for date functions, have you got a separate date table?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

it still does not work. My date table is named date.

were do I need to put the link between both tables?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I did set up a relationship between DATE and TABLE 

       both formulas do not work. I should be something simple but I can not find it...

      • vanessafvg's avatar
        vanessafvg
        Community Champion
        7 years ago

        Anonymous  when you say it does not work can you please give more information?  what are you getting? what are the data types of both of the dates you are linking on?  is there any chance you can share you file?

         

        if not please share some extracts from your data so i can recreate the issue, you need to copy and paste the data not put images.