Forum

Hi Ian, The 'from web' connector gets data from a web page. It can't download the file for you and then open it. Are you able to link directly to t...

Hi Dave, Thanks for uploading your file. You need to edit the Pivoted Column step and click on 'Advaned options' and select 'Do not aggregate' from...

Hi Rakesh, Thanks for clarifying. You can use lookup formulas to find the components for each item from the Rate Weight, Zone Zips, Priority, Stand...

Hi Tarun, Welcome to our forum. You don't need a measure for this. Build your PivotTable with the following fields: Filters: Application...

Hi Rakesh, Welcome to our forum. Thanks for sharing your file, however your question isn't clear, even after I added paragraph breaks to make it ea...

Hi Jordan, Welcome to our forum! It's great to hear you're giving PivotTables a go. I'm sure you'll find them super useful. To answer your quest...

Hi Maarten, I can't tell from the image which is the fact table, but based on the direction of relationships in the image attached it appears there...

Hi Robb, Create another table with the week start dates and week numbers, then merge that table with your data table to bring in the corresponding ...

Hi Amberlie, Congratulations on your progress through the courses. I recommend you complete all of the courses before you try to implement the tech...

Hi Nancy, Please see this tutorial on showing the percentage of another PivotTable column using Power Pivot. Mynda

Yeah, I'd sell them myself except it'd be breach of copyright.

Hi Clio, Nothing attached. Be sure to click the 'Start Upload' button after selecting your attachment. Mynda

Hi Tom, Welcome to our forum! Unfortunately, the Excel t-shirt I wear in my videos isn't available anymore. I had a look at their eStore but the...

Hi Maria, When I open the file I get an error for the Custom column formula because the data type for the receipt date and due dates are date/time....

Hi Maria, You can't separate the query from the Power Pivot model file, so the answer is easy, you need one file with both the query and the Power ...