PDA

View Full Version : Power Query (Get & Transform) & M code



Pages : [1] 2 3

  1. Inserting new rows in Power Query report
  2. Power Query_Refresh data_Not populating
  3. Power Query - Transpose Matrix
  4. Power Query - importing Dynamic Named Ranges ("=Excel.CurrentWorkbook()")
  5. Conditional Power Query formulas
  6. Power Query: Associate Each Customer Sale With A Supplier Order ID
  7. Split Power Queries
  8. DataFormat.Error in Power Query
  9. CSV without Carriage Return Importing as Single Column
  10. Master Power Query with our book - M is for Data Monkey
  11. Installing Power Query
  12. Power Query New Versions - How Do I Know?
  13. adding a column to PQ table
  14. ISO Date
  15. Power Query slow and unstable after February update
  16. Power Query M Question - Time in Pod/training
  17. M Formula for 'Text' Months from Week Values
  18. Power Query will not load all rows
  19. Filtering Salesforce data before loading it to the model
  20. Applying Cashflow Categories to transactions
  21. Working days
  22. Pass parameter from worsheet cell to Oracle
  23. Power Query updates for Excel 2016 Professional Plus
  24. Dynamic Filter in Power Query
  25. how to do nested ifs?...
  26. Permissions Error on Data Refresh
  27. Table.Addcolumn
  28. BASE_DATA_1 - QUERY_1A - QUERY_1B refresh
  29. How to import specific cells from several Excel files
  30. Power Query workbook save
  31. Splitting a text column with multiple entries from 1 to Many
  32. Custom Column with yesterday's date
  33. IF on a date field
  34. Power Query + Dynamic SQL WHERE IN
  35. Power Query - Users unable to download workbook due to data source error
  36. "IsNot" or "IsNotNull" Formulas
  37. Power Query Update Available (April 26, 2016)
  38. Help needed: Transforming this data into useful tabular format for analysis
  39. Update Source By Refresh Instead of Editing Query Detail
  40. Text.ToList - how to reverse this step
  41. How to replace a data source
  42. Keeping the file path whatever the current workbook file path is
  43. Rept function in Power Query?
  44. Referencing two queries
  45. Refreshing Pivot Tables after a PQ refresh
  46. Slow loading times
  47. Dates getting converted from European dd/mm/yyyy to US mm/dd/yyyy Format
  48. Appending queries without refreshing all of them...
  49. Projected Ending On Hand calculation
  50. Selecting a field
  51. 'Prompting' for parameter
  52. Create a new column with the number of occurences of a delimiter in another column
  53. Many to Many nightmare
  54. Power Query Update Available (as of Monday, May 23, 2016)
  55. Need help eliminating certain rows
  56. Extract the Month formatted as "MMM" from a date field (column)
  57. Dates in CSV Files
  58. Content of some lines in one line including "line break"
  59. SharePoint connection within PowerQuery/PowerPivot
  60. Multiple table in PowerPivot with PowerQuery
  61. Business Objects files and consistency
  62. VLOOKUP (as per Ken P)
  63. Total row on query
  64. Power Query Update Available (as of Tuesday, June 21 2016)
  65. Defer Updating of Pivot Tables until ALL Power Queries Refreshes have been completed
  66. Date data wont change to date format
  67. Excel 2016 June Update Get & Tranform issues
  68. Power Query: find which column contains my value and return column name
  69. Using a parameter table to filter dates column
  70. Subtotal of duplicate rows (one subtotal per duplicate, keeping all duplicate rows)
  71. Unstacking Columns in Power Query
  72. Reading files from a OneDrive for Business folder
  73. Heads Up: another silent release of the Power Query Add-In last week.
  74. How to add the file name (month name) to the contents file for monthly credit card..
  75. Remove rows below text
  76. Unpivoting Date Columns
  77. Power query - exchange server - possible to connect directly to one folder in mail
  78. Power Query Date.EndOfMonth Function Issue
  79. Add new row for multiple delimited values in a cell
  80. Power Query Update Available (as of Monday, July 25 2016)
  81. Calculate Multiple Columns by Another
  82. Problem Transitioning from Excel to Power BI ... Using Parameters
  83. Problem Transitioning from Excel to Power BI ... Using Parameters
  84. IF and AND - multiple conditions
  85. Merge with previous step
  86. Open External Workbooks
  87. Two tables, identical columns and rows, some blanks in cells, need to combine data
  88. FIFO Allocation with a fixed amount
  89. Questionnaire output
  90. Combine totals for two rows without grouping and losing columns.
  91. CSV file - number of columns import limited by parameter...any way around this?
  92. Querytable FillAdjacentFormulas
  93. Daily utilizaiton (occupancy) calculation
  94. Transform a Column
  95. Automate billing spread with P/Q
  96. Unpivoting Column and Format.Data error handling
  97. Recursion problem
  98. Power Query Update Available (as of Thursday, August 25, 2016)
  99. Ribbon info for Power Query to disable visibility using VBA
  100. Merge dynamic columns' name
  101. Selecting delimited data in multiple columns
  102. Dealing with bad data in columns - automating the removing duplicates
  103. Replace all NULLs with 0 in a table with multiple columns except in 1st column
  104. Substitute for Excel Function: TEXT(A2,"000000")
  105. Questionable application of PQ; transpose column headers into columns and append sets
  106. Multiple lines in IF statement
  107. Excel file in SharePoint folder as the data source for Power Query
  108. PowerQuery - Query SSAS Cube using List of Parameters
  109. Creating a "fulfilment table
  110. Use data from Table in Power Query
  111. Managing connections
  112. Parallel connections to DB
  113. Group after Appendig to tables
  114. Pick up MAX version number for each item
  115. Excel 365 Power Query - Moving columns/fields not working
  116. Row action missing in Query From Folder
  117. Use Power Query to Feed a Web Form
  118. Extracting first two rows from each of several folder files
  119. Splitting Columns by Numbers or Characters
  120. Power Query Update Available (as of Thursday, October 6, 2016)
  121. Data type when adding column
  122. Parameter to switch a query 'on' or 'off' without creating errors
  123. Powerquery will sometimes stop in middle of an API call
  124. Error Message When Grouping Data - "DataFormat.Error we couldn't convert to number"
  125. PowerQuery only brings in 1 column of data
  126. Apply a function to all columns in a query
  127. Formula: Is one of several Codes in one of several Fields?
  128. Converting B/M to number & % to decimal
  129. Date/Time import issue
  130. Logical test if first character of a string is a number
  131. Referring to columns by position rather than name
  132. Reading dbf files - error "Invalid SQL statement"
  133. Group By question
  134. Calculate Tenure in Power Query Customer Column
  135. Dynamic Group by (referencing cell value)
  136. Power Query Update Available (as of Thursday, October 27, 2016)
  137. Out of Memory error consistently happening with Power Query
  138. pivot/transpose/fill
  139. Parse for numbers only
  140. Expand number of columns after each merged workbook?
  141. Nested if's or creating a fnSWITCH function
  142. Power Query to extract data from a password protected website
  143. Combine Multiple Workbooks in Power Query - When File Structures are Different
  144. Need help in Power Query Date Requirement
  145. How to get the Last Refreshed date from a Workbook Query?
  146. Median
  147. Splitting a field and using part of the split result
  148. Run Power Query Routines in Sequence
  149. Power Query - Fill up -- conditional?
  150. Matching Text Columns
  151. Find Leading Spaces in Powerquery
  152. Find Leading Spaces in Powerquery
  153. Update Excel 2016 PQ ('Get and Transform') to Latest Version
  154. Powerquery transform text to date conversion error
  155. Transpose Columns with a twist
  156. Extract Cell Color with M
  157. Label in same column as data
  158. Power query - add time to date
  159. Power query - add time to date
  160. Expanding table scraped from web with more than 9 columns - cols are out of sync
  161. Out of stack space
  162. Refreshing Power Query / Power Pivot
  163. SAP BusinessObjects Universe with Optional Prompts
  164. Carriage Return Character in Power Query
  165. Expanding expanding data...!
  166. Text File into Table
  167. Using Power query to transform a profit & loss report into pivot table readable data
  168. Merging two CSV on job profitability where like jobs need to be added together...
  169. Power Query to only update records that have changed
  170. Power Query to combine file path with file name and add cell reference to extract inf
  171. Replacing null values in a column
  172. Urgent - Splitting text from numbers in a column, please help
  173. Merge Cell issue and Unpivot first row only
  174. Problem with "Remove Duplicates" in "Get & Transform" (Excel 2016)
  175. Error with refreshing query from shared file via Dropbox
  176. Expand column with a table in it containing variable numbers of columns
  177. sql select in (), with arguments from xls sheet
  178. Duplicate data in columns
  179. Change the 4 digit year in date to 2 digit
  180. Power Query specifications and limits while working with Text files
  181. Keep order of columns when expanding
  182. Power Query conditional join between 2 tables
  183. Datedif Date to Words Possible in Power Query
  184. Making Column Count dynamic (not the names but the number of columns)
  185. Query parameter always using current value instead of query result?
  186. Import Excel - force all columns as text
  187. Match parts of strings in a lookup table and return another column
  188. Removing text from column referenced on list
  189. Power Query Running Total with Multiple Criteria
  190. Power Query Running Total with Multiple Criteria
  191. Three sets of columns to 1 set...
  192. Group by solution
  193. PowerQuery IsDate function
  194. Date Parameters
  195. Cartesian Joins by rows with the same ID
  196. Number of tables in Navigator limited to 10,000. Edit Query does not pass values back
  197. Receive error when attempting to update
  198. Filter and transpose data from rows to column
  199. Power Query Help
  200. Power Query with dependent queries
  201. Table Equations adjacent to Power Query result
  202. Query Editor - Taking a LONG time to refresh as I work on query steps
  203. Change Data Type on all but 1st column
  204. Import from several CSVs to separate sheets in a workbook
  205. How to save a sorted query to the data model (for performance reasons in Power Pivot)
  206. Flattening tree records
  207. How to convert function parameter from text to Table Column reference
  208. Refresh Queries at different times
  209. Query Refresh problem
  210. Power Query Header Format Change on Refresh
  211. Pivot Not Refreshing Until Slicer is Changed
  212. Please rebuild this data combination
  213. How many workbooks can Power Query handle?
  214. Convert Data from "top to bottom" to "left to right" including some adding values
  215. Data Extraction & Creating relationships in excel file
  216. Change value based on value of another field
  217. Keep the most recent assigned salesperson
  218. Power Query - Add Columns Conditional
  219. Append Tables or use Multiple Tables
  220. merge non-contiguous and contiguous range periods with the same attribute
  221. Parameterizing a column name
  222. Create Daily Periodic Interest Rate Index from Monthly Summary
  223. Power Query refresh and Solver add_in
  224. Rearranging overhead costs in financial statement using power query - possible?
  225. Help. Ranges date filter with PQ
  226. Split Column by Delimiter but Retain Text Format
  227. How to exclude certain sub-folders when using Get Data From Folder option
  228. Remove Null Rows
  229. Excel 2010 crashing since installing Mar 17 power query update
  230. Tables not showing up in Query-Editor
  231. Refreshing a query from another query
  232. Dynamic Cols select
  233. Transpose Duplicate Rows into Repeated Columns during Query Merge
  234. How to edit source data after you've created your data model and measures in pwrpivot
  235. LEFT + SEARCH Function Help
  236. Time problem
  237. Not Able to Unpivot Nested Headers and Multiple Spreadsheets
  238. First column missing in query results
  239. How to handle #n/a
  240. Non existent error in Append query
  241. Search (Text Contain) multiple values
  242. Overwrite columns
  243. Working with Column Headers in Power Query
  244. Using PowerQuery as a self-help interface to database applications
  245. Pivoting data by month column and summing the resulting months by row...problems
  246. Import file from folder; file & data is duplicating
  247. Pivot multiple columns +
  248. Refresh power query while workbook protected
  249. Table.TransformColumns with reference to another column?
  250. Power Query and Amazon Sales Data