Forum Discussion
Helper Iissue with weekly previous year sales
i haves sales table and calender table , both tables have dates upto yesterday only ( sales also upto yesterday only)
when i selected year in filter pane(make sure not in slicer) i need to have current year weekly sales of selected year in one measure(current selected year sales) and previous year sales (not for the same period, but for all the dates, for current year weakly sales upto yesterday but for previous year i need weekly sales upto year end , make sure i need weekly sales)in other measure.
please help me its urgent
thenk you so much in advance
2 Replies
- lbendlin
Super User
Weeks and Years are incompatible. You better have a calendar table that clearly indicates the week number for each day in each year.
Your doing YoY calculations but your calendar table doesn't contains for the entire year.
Extend the calendar table end date to the end of the year.
