Forum

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...

Hi Jose, Please supply the workbook that you want this to work with. It's very difficult to provide you an answer without that workbook's data and...

Hi John, No need to post the same question in different forums, just once is enough. The logic in your question is difficult to understand. Why...