Forum Discussion
Solved
DATESYTD doesn't work
Dear all, I have a report where I track my orders. I created a calendar table based on my dates in my data and marked it as a date table. Normally I can calculate YTD as a measure but due to new...
What context and visuals are you using this in?
You can either
OPTION A: update your formula to use manual reference to TODAY(), such as:
YTD = CALCULATE ( [New Fulfillment Rate2], YEAR(FactTable[Date]) = YEAR(TODAY()))or, OPTION B: add a year context to your report by putting a date filter on the page that has 2020 as the max year.
What context and visuals are you using this in?
You can either
OPTION A: update your formula to use manual reference to TODAY(), such as:
YTD =
CALCULATE ( [New Fulfillment Rate2], YEAR(FactTable[Date]) = YEAR(TODAY()))
or, OPTION B: add a year context to your report by putting a date filter on the page that has 2020 as the max year.
Hello Allison,
sorry for late reply. thank you for your help. both of your options worked.
have nice week.