Forum

Hi John, Can you please expand on some of the logic? e.g. why should the first date/time 3/20/2020 9:01 not be marked? Likewise, why are we marking...

Hi Cheryl, Of the 5 queries generated when you import files from a folder, only two have the file path; Sample File and the final query under the '...

Hi Aye, Click on the filter pane. You'll see the filter options for that visual. Likewise, the filter icon on the visual itself. Mynda

Hi Norman, The XLOOKUP function is a new tutorial. I suspect you downloaded the supporting files prior to me releasing the XLOOKUP video. Please do...

Hi Mahmoud, I asked because you posted your question in the 'Power Pivot' forum. The calculation can't be done with a regular PivotTable, sorry. Yo...

Hi Aye, Your filters pane is collapsed in the second image, but have you tried removing the filter in the Filter pane? Mynda

Hi Claudine, Hard to say, but if you click in the whitespace of the error cell you'll see the reason at the bottom of the Power Query screen. My...

Hi Norman, Welcome to our forum. The file is called excel_2019_3.1_18_xlookup.xlsx and is in the zip file for this course. If you open the zip file...

Hi Mark, Please show me screenshots of your PivotTable field lists so I can see ALL of the tables the fields in your PivotTables are coming from. M...

Hi Mahmoud, This isn't Power Pivot, this is a regular PivotTable Calculated Field. You can't do a formula like that with Calculated Fields because ...

Hi Mark, I understand what's happening, so unfortunately the file didn't help me troubleshoot. I am confident that the table your Slicer is assigne...

Hi Brian, You can email it to me if it contains confidential data you'd rather not share on the forum. I delete files after answering questions...n...

Hi Mark, Welcome to our forum. Power Pivot Slicers will only show data in the model. If it's showing 'blank' then that indicates there are some ...

Hi Vivian, Excel 2013 doesn't have bounding boxes for the Slicers. I do mention this in the video but perhaps it wasn't clear. In Excel 2013 you...

Hi Cheryl, Each query in the image you shared is a separate query, so you can't just copy one as they are dependent on each other, as you have foun...