Marshallpb1
New Member
So, I updated a date calculation column to reflect week starting from week ending in my source file. It looks like it updated when I did a refresh, but the relationship between that column and a calendar table doesn't seem to recognize the change. Originally, using week ending, it was moving up the week number up a week, so that some of my week 44, 2022 data was getting lumped into week 45, 2022.
My pivot table is reflecting the week number (calendar table) incorrectly. Week 45, 2022 should now be included in Week 44, 2022 but the chart will not update with the changes
Appreciate any insight or workaround that can be provided. I've tried to create a duplicate file and editing the source file, but ended up with same result. Is there anyway to replace it without having to recreate the dashboards and slicers I've mapped to these tables?
My pivot table is reflecting the week number (calendar table) incorrectly. Week 45, 2022 should now be included in Week 44, 2022 but the chart will not update with the changes
Appreciate any insight or workaround that can be provided. I've tried to create a duplicate file and editing the source file, but ended up with same result. Is there anyway to replace it without having to recreate the dashboards and slicers I've mapped to these tables?