Forum

Hi Rosemary, Looks like the web page, which is the source data for that example, is no longer available. The revised file attached uses source data...

Hi Carol, The Power Query editor only shows a preview of the data, but when you Close & Load it will import all rows. Have you actually tested ...

Hi Rosemary, As per our email exchange I understand you are looking at session 7.03 and 7.04 of the course. If you have problems implementing the t...

Hi Mitul, I suppose it's possible that the workbook became corrupted. It might be the PivotTables, but it might be something else. You can learn...

Hi Mitul, You must place a value type field in the row/column labels area of your PivotTable and group that. e.g. date fields, your 'Desired Price'...

Hi Mymalone, Thanks for sharing your file, however you don't have a tab called 'PS', but you do have an orange tab called 'SM' with charts on it, s...

Hi Ken, Character 10 requires the Wrap Text cell format to be applied for it to actually wrap. If you format the cells with Wrap Text the wrapping ...

Great! Glad it was what you were after.

Hi Matthias, Select the 3 columns you want to derive the max and min from > Add Column tab > Statistics > Max. Repeat for Min column. N...

Hi Jon, The formula will depend on how your data is structured - what fields are in what tables and what are the relationships. Please provide a mo...

Hi All, A fix is being worked on by Microsoft and will be released ASAP. Mynda

Hi Torie, Great to hear you're embracing the tabular data layout 🙂 You can use PivotTables to group your dates into 7 day periods: Let me kn...

Hi Mike, Thanks for the screenshot. Have you tried switching the two row label column positions? I can't see what they're called but since they'...

Hi Rosemary, The problem with this example appears to be that the expression argument isn't an explicit expression or measure. It appears to be re...

Hi Rosemary, Please email it to me ([email protected]), or share via DropBox. Thanks, Mynda