How to mark current year in a YTD formula

Jennifer Reed-Papadopulos 0 Reputation points
2023-05-11T16:32:54.5433333+00:00

When I had One year (2023) on my data set my formula worked fine. (I incorporated REMOVEFILTERS since I had a month slicers and did not want it to move my YTD formula.)

Now that I have from 2023 to 2028 my formula marks NO mistake, but come back blank. I have no idea how to mark 2023 as current year or make this work.

Please help!

YTD Actual 2023 = TOTALYTD('Database'[Actual 2023],'Database'[_Period Clean],REMOVEFILTERS('Database'[_Period]))
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,071 questions
{count} votes