Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi,
I have a report that is showing data on a week number basis. I have two slicers that allow me to select the year & week.
The data below shows the sales stats only within that week.
But I would like to add a few year-to-date measures to that report page, which start from the selected year until the last day of the week.
My plan is to create a table visual that has only has an interaction with the year slicer, but not with the week slicer.
But then I still nead to create a YTD measure that somehow limits the calculation up to max(week_slicer).
Any ideas of how I could accomplish this?
Solved! Go to Solution.
Actually, I think I just figured it out, but perhaps you could help me guide on whether that is the ideal way of doing it.
I created the following measure:
YTD - Total Revenue = var selected_week = MAX(BasicCalendarEnglishDynamic[ISO WeekNumber]) RETURN CALCULATE(SUM('IS Orders'[TotalDue]), ALL(BasicCalendarEnglishDynamic[ISO WeekNumber]), BasicCalendarEnglishDynamic[ISO WeekNumber] <= selected_week)
And I abondoned my initial idea of disabling interaction for that specific visiual.
Actually, I think I just figured it out, but perhaps you could help me guide on whether that is the ideal way of doing it.
I created the following measure:
YTD - Total Revenue = var selected_week = MAX(BasicCalendarEnglishDynamic[ISO WeekNumber]) RETURN CALCULATE(SUM('IS Orders'[TotalDue]), ALL(BasicCalendarEnglishDynamic[ISO WeekNumber]), BasicCalendarEnglishDynamic[ISO WeekNumber] <= selected_week)
And I abondoned my initial idea of disabling interaction for that specific visiual.