Forum

Hi Femco, Please provide some sample data so we don't have to recreate it. Please provide an example (image, table, workbook) of what you want y...

Hi Salim, Please check these links What is Data Streamer? (microsoft.com) Enable Data Streamer in Excel - Excel Data Streamer | Microsoft Doc...

Hi John, I don't see why that wouldn't refresh on another PC. When you say it doesn't work for others, how so? What is MyDataSet? Perhaps th...

Hi Kirsty, Try putting Table.Buffer inside Table.Sort e.g. Table.Sort( Table.Buffer(#"Extracted Day Name1"), .... ) regards Phil

Hi Patrick, You can simplify your code to this =VAR ThisDeptID = MAX(dataPnLDetail[DepartmentOrder]) RETURN if(ThisDeptID <=4,ThisDeptID) ...

Hi Barry, The Listbox has a setting that controls the number of columns it contains. You had it set to 1 column, it just needs to be set to 4. ...

Hi Erik, I'm having trouble picturing things without seeing the data. Can you please attach some sample files/data and an example of the final res...

Hi, You need to explain and show through examples, what transforms you wish to perform. The file you supplied has no queries so I am none the wise...

Hi, You could modify the Transform Sample File query (it's one of the Helper Queries created automatically in PQ) so that it removes the first row ...

Hi Chad, You can do this with a combination of data validation, tables (for lookup) and this formula =XLOOKUP(D4,ZoningDistricts[Zoning District...

Hi Falk, Are you trying to access the Sandbox or live data? If you are trying the Sandbox, I believe it only contains data that you put there b...

Hi Amanda, If you put columns for Brand and Size in the ItemRunData table, you can then sort/highlight the table based on those columns. regards...

Hi Carl, Please attach your file when asking a qs - without your file I can't see what you are doing or what may have gone wrong. If you look at...