Forum

Hi Mark, Great question. Chris Web has a post on this here; Mynda

Hi Wil, I've moved this topic to General Excel Questions as it's regular PivotTables, not Power Pivot. If you want to use a Slicer then you need...

Hi Lea, This tutorial explains Data Validation Lists, which will do most of what you want. However, it won't correct spelling and make suggestions ...

Hi Eliane, Unfortunately that's not an option yet, but you could reduce the display to show the values in thousands/millions/billions etc. this wil...

Hi Raj, Power Query doesn't require coding. It's mostly point and click GUI. Sure, you can code it if you want, but most people won't need to. I...

Hi Raj, I think you would do best to learn Power Query so you understand how you can leverage it for your project. I can tell by your questions tha...

Session 6.12 and 6.13 🙂

Hi Raj, The file containing your query should be your ‘master file’, or you put the query in your master file. This way you can close and load the ...

Hi Anne, Power Pivot OR functions are limited to two criteria. You have 3. Really these types of formulas are best done in Power Query (not just be...

Hi Anne, This can't be done with Power Pivot. You can do it with Power Query though and I cover this in session 7.01. Mynda

🙂 glad it's sorted now and you're one step closer to Power Pivot/Query mastery!

Hi Anne, Yes, they can read the file, but they can't refresh or alter the PivotTable structure i.e. no Slicers, filtering, changing layouts etc. An...

Hi Thomas, These tutorials should help you identify the different uses for calculated fields vs calculated items: Please let us know if ...

Hi Timoth, If the Answer column contains numbers then you don't wrap the 5 part in double quotes. Also, 'if' in Power Query doesn't have opening an...

Hi Anne, I can't see anything wrong with the formula, but maybe your data types for the date columns aren't set to date? Hard to tell without se...