Forum

Hi Prashani, You can use this formula: =INDEX($E$3:$E$4,SUMPRODUCT(ISNUMBER(SEARCH($D$3:$D$4,A3))*ROW($1:$2))) As explained in this post o...

Hi Celeste, Nope! But you can copy the query into the new workbook 😉 Or refer to lesson 4.21 of the Power Query course on reusing and sharing que...

Ah, that'll be because the OneDrive sync client is uploading the changes from your PC to the OneDrive file. So, why were you getting the error initial...

You didn't mention OneDrive initially. If you're referencing an Excel file on your hard drive it must be closed for refreshing. As for OneDrive, I hav...

No, the source workbook must be closed for Power Query to refresh, sorry.

Hi Cheryl, I suspect the measure is nested in a different table to the one you expected it to be set up with. I recommend you use the search bar at...

Wow, great result 🙂

Hi Lea, I too get the error and am forced to repair the workbook in order to open it. When it opens after the repair there is no query. If there wa...

Hi Angelo, Sounds like a limitation. Modern versions of Excel for the PC don't have this issue, but I know it used to be an issue in earlier versio...

Hi Vincent, Thanks for sharing your file. It's a little over my head, but I expect you'll need to write a measure similar to the correlation measur...

Hi Kenneth, Power Query doesn't have the European date option, but this post offers a workaround. Mynda

Hi Peter, Welcome to our forum! If you right-click the first query in the left hand query list of the Power Query editor, then select 'Reference...

Hi Vincent, Please attached a file (Excel or Power BI) with your sample data. Thanks, Mynda

Hi D'Anna, Welcome to our forum. Unfortunately, you can't change the orientation of the vertical axis text. The labels closest to the bars will ...

Hi Alan, Thanks for sharing your file. First, you need to unpviot the data so that it's in an tabular format. You can use Power Query to unpivot. ...