PDA

View Full Version : Power Query, Power Pivot and Power BI



  1. Problem with importing database to my powerpivot excel file
  2. PQ - VLOOKUP on Matching Multiple Criteria
  3. PQ - Comparing two columns in the same table and returning unmatched
  4. PQ - Extract numbers from column with condition
  5. PQ - Filter List Based On Group
  6. PQ - Number.From in PowerBi
  7. PQ - Match across tables - and pick up values
  8. PQ - Transforming Text to Date in Power Query
  9. PQ - Clean Data Multiple Workbooks Varying Columns
  10. PQ - Multiple pdf tables
  11. PQ - Power Query: search multiple columns against a list of values?
  12. PQ - Only year-week used in data file - Best practice
  13. PQ - Filtering by filenames
  14. PQ - M Code to strip almost all non-alphanumeric characters from a column
  15. PQ - Choose power query table destination range & sheet
  16. PQ - Extracting a number that is a percentage from text
  17. PQ - Use table to edit values of another table in Power Query
  18. PQ - Return unique values in row based table
  19. PQ - make new column by extracting a word from a cell that contains a $ sign
  20. PQ - Power Query split?
  21. Power Query Formula to Make Column Keep Retain Alphabetic When Refresh
  22. Power Query : Maximum Append Rows 5000 Rows
  23. PQ: Formula Sort Only Not Blank/Rows Data
  24. Help to Transpose of sorts in PowerQuery