Forum

Hi Fran, You can add a helper column to the table that counts the scores in columns E:Q that are less than 4. Then filter that column to only displ...

Hi Muhammad, Power Query isn't designed to be the tool for aggregations like this. Power Query is for getting and cleaning your data ready for load...

Hi Tykru, Thanks for sharing your file. You don't need Power Query for this. You can do it with a PivotTable > Show Values As > Difference Fr...

Hi Arti, Welcome to our forum. The # sign is a digit placeholder. Insignificant digits are not displayed by the #, whereas with the zero they ar...

Hi Kathie, You're best to remove the other PivotTables to their own sheets because there will be something that has changed that's resulting in the...

Hi Stefano, In your Excel formula you had MOD(Text.Middle(B6,10,2),40) The Modulo step in Power Query replicates this calculation in your Excel ...

Hi Tykru, Can you please upload a sample Excel file with your data? Be sure to connect the query to data in the Excel file, not an external source....

Hi Stefano, Please see file attached. There are quite a few steps, but it makes no difference to Power Query's efficiency if it's not squashed into...

Thanks for your kind words, Cindy! Glad you figured out a solution. In regards to your expression error, yes, Power Query cannot access an open fil...

Hi Shantanu, As Catalin said: "In power Pivot editor window, [LastDate] will always be ... the last date, because there is no row context in there,...

Hi Deanna, Thanks for posting your question in the forum. I've moved it to the public dashboard group as this will get more views and therefore mor...

Hi Stefano, You can't reference cells in Power Query, so this: Text.Middle(B6,7,2) will not be recognised, unless you happen to have a column ca...

Hi Fred, It looks like you're using Excel 2010, in which case you'll find the icon to insert a Slicer on the Insert tab of the ribbon. In fact, in ...

Hi Kevin, Once you've merged the columns with the hyphen, select the merged column > Transform tab > Replace Values. In the Advanced Options ...

Hi Karen, I'm not aware of any way to connect to a cloud folder. The solutions I've found recommend you sync the Google Drive folder to a folder...