Steven Weydert on 26 Apr 2020 09:00:20
Where is the New Calculated Table feature in Power Pivot for Excel? Four years ago I scrambled to my computer in exhilerated anticipation when I discovered Power BI had bi-directional cross-filtering capabilities only to discover this critical functionality was only available in Power BI not Power Pivot. Similarly, being able to easily create new intermediate calculated tables in Power Pivot would be a game changer but it too appears to be only available in Power BI. This, once again, is quite frankly devastating. Please tell me it's there and I just can't find it.