Forum Discussion

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 for 2018.

posting dates en invoices are starting in 01/01/2018 until now.

vanessafvg
7 years ago
Anonymous you need to have a date table for date functions, have you got a separate date table?

6 Replies

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
  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?
  - vanessafvg
    Community Champion
    7 years ago
    Anonymous have you set up a relationship?
    
    maybe this can help? https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions