Forum Discussion
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...
Anonymous you need to have a date table for date functions, have you got a separate date table?
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...
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.
it just maks the sum of the whole year and not a year to date total.
I started over with only two table. Same result. I'll share it in a privat post.. no secrets in it :)