Forum

Hi Celeste, Are you loading your data from Power Query to Power Pivot or only from Power Query to an Excel Table? If the former, then it should go ...

I don't have Premium so I don't think it's that. I do have Pro, so maybe it's related to that, but I doubt it. It's more likely to be some regional se...

I'd have to see the PDFs and your query to troubleshoot as I can't reproduce that issue. If the data is sensitive, you can email it to me website at M...

Hi Dieneba, Ideally your data should be modelled in a star scehma design This means creating dimension tables for attributes that are not requi...

At the Navigator dialog box are you able to see the tables and select them by checking the box for 'select multiple items' and then checking the box f...

Hi Patrcia, It's difficult to troubleshoot without seeing the query and files. It's particularly odd that some data comes in but not all. I won...

Hi Charles, There are a few ways to tackle this and depending on which version of Excel you have, there are also some functions that you can use. ...

Hi Filipa, It's difficult to be specific without seeing your file, but have you watched lessons 9.06 - 9.08 on the ALL, ALLEXCEPT and ALLSELECTED f...

Hi David, The only way to remove blanks from Slicers is to ensure they don't show up in the PivotTable, and you can do this by filtering them out. ...

Cheers, Todd. I think this is probably a candidate for a recursive lambda function, but I didn't have the headspace to write it last night!

Hi Todd, Thanks for clarifying. I simplified it from this: =IFERROR(VSTACK(FILTER(FILTER(DROP(SORT(UNIQUE(TOCOL(D60+DROP(REDUCE(0,E60-D60,Custom...

Hi Lori, Welcome to our forum! Please upload an Excel file with some dummy data, the PivotTables and a mock-up of what you'd like to see so we c...

Thanks for clarifying, Todd. That sure is a doozy! I couldn't follow how you're supposed to fill out the flexible working table to trigger the formula...

Hi Rose, The issue is that you haven't changed the date data type using 'change type using locale'. Please read the file called 'Read me first' t...

Very nice, Todd. I'm not sure where the 9 day fortnight column is that you're referring to. Here's a tip for conditional formatting: This formul...