This topic contains 1 reply, has 2 voices, and was last updated by 
-
Posts
-
Good day
I would like to know if there is a work around the YTD funtion where the last week of a calendar year normally include dates from the previous / next year.
When I do a YTD it excludes the last 3 days for 2014 which is correct but i would like to include them in the YTD Function
Please see attached
The YTD functions have an option for year-end-date (meant to accommodate different fiscal years), but not for a custom year-start-date.
You will have to write a custom formula based on weeks. You could find some insights in Power Pivot and Power BI in chapters that discuss custom calendars.
The forum ‘Power Pivot’ is closed to new topics and replies.