SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,300 questions
How to mark current year in a YTD formula
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 34%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Jennifer Reed-Papadopulos
0
Reputation points
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]))
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 51%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
Emily Du-MSFT 44,311 Reputation points Microsoft Vendor2023-05-12T08:42:08.01+00:00 Where did you use this formula?
Whether some codes for SharePoint or query formula used in the SQL server?
Sign in to comment