Forum Discussion
Solved
Dynamic YTD across multiple years
Hello, after hours of reading different posts and trying out formulas, I still haven't found a solution for my problem. There are two columns from my table that are relevant here: Sales units an...
We finally came up with a measure that works for our purpose:
YTD sales units =
TOTALYTD(SUM('Sales'[Sales units]); 'Sales'[Date];MONTH('Sales'[Date])<=MONTH(NOW())
We finally came up with a measure that works for our purpose:
YTD sales units =
TOTALYTD(SUM('Sales'[Sales units]); 'Sales'[Date];MONTH('Sales'[Date])<=MONTH(NOW())