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())
Unfortunately, it doesn't work either. It just displays all sales from the available starting date until now but not the sales made in the last years until november.
Hi Kt1097,
Fowmy 's formula looks well, I'm not so sure why they do not work on your side. Can you please share a pbix file with some dummy data and expected results to help us clarify your scenario and test coding formula?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng