Home › Forums › Power Pivot › Converting PIVOT TABLES to cube members Tagged: pivot table; powerpivot; measure This topic contains 2 replies, has 2 voices, and was last updated by sjhc1177 7 months ago. Viewing 3 posts - 1 through 3 (of 3 total) Author Posts September 4, 2019 at 8:55 pm #18160 sjhc1177Participant Started: 25Replies: 28Total: 53 Hi, I’m trying to convert my last report that has a pivot table to CUBEMEMBERS. I would like this so the structure and length can always be the same. Plus my formatting, fonts… will match. But I have BRAND names that change each time the report is rerun. I don’t want to create Excel formulas to trick the system. I would rather my whole report be the same logical plan. Below is an example of a table converted. This part will keep changing, any thoughts? (&[APEA10 – CT5458]”)) =CUBEMEMBER(“ThisWorkbookDataModel”,”[tblInvMaster].[BRAND – MODEL].&[APEA10 – CT5458]”) Thanks September 5, 2019 at 1:34 am #18162 tomallanKeymaster Started: 0Replies: 417Total: 417 You may need to re-think your measures to generalize how they handle the brands that change from month-to-month. Difficult to say more unless you can post a small workbook sample that shows how the values change from month to month. September 5, 2019 at 2:01 am #18163 sjhc1177Participant Started: 25Replies: 28Total: 53 Hi, I have some sample data. Is there a way for me to upload it privately or send you a dropbox link. Thanks. Author Posts Viewing 3 posts - 1 through 3 (of 3 total) The forum ‘Power Pivot’ is closed to new topics and replies.