Skip to content
Trainings, consultancy, tutorialsTrainings, consultancy, tutorials
Trainings, consultancy, tutorials
Understand it right now!
  • Home
  • For corporations
  • Individually
  • Consultancy
  • References
  • Pricing
  • Tutorials
  • Contact
  • Where
  • EN
    • CZ
    • SK
    • EN

  • Registrace
  • Přihlášení
 0
  • No products in the cart.

Subtotal: 0 Kč

View Cart Checkout

 
  • Home
  • For corporations
  • Individually
  • Consultancy
  • References
  • Pricing
  • Tutorials
  • Contact
  • Where
  • EN
    • CZ
    • SK
    • EN

Tutorials

You are here:
  1. Home
  2. Tutorials
  3. Power BI
  4. Power Query M language

Power Query M language

  • Conditions in Power Query M language
  • Custom function basic syntax in M language (Power Query)
  • Excel, which downloads and merges all data from the specified folder
  • Keep sorted table for Group By, using Table.Buffer
  • List.Accumulate and column calculations
  • List.Transform – converts list items
  • Merging of all columns in Power Query – regardless of their names
  • Merging of two ROWs in Power Query
  • Power Query – how to find a nth smallest or largest value in table or group
  • Power Query and referencing sheet with variable name
  • Rename of first (or n-th) column in Power Query
  • Running totals in Power Query, using the List.Range function
  • The List.Range function, extracting values from specified rows in a column
  • The Table.ColumnNames function and its practical use
  • Value from Excel cell directly to Power Query

Leave a Reply

Your email address will not be published.

CAPTCHA
Refresh

*

clear formPost comment

Did you know we have a LinkedIn page?
For companies
Interested in company training?
Excel trainings from beginners to experts. And other Microsoft Office applications as well.
MORE INFORMATION
Individually
  • Consultancy for complex spreadsheets creation
  • Preparation for your new job
  • Preparation for job interview
MORE INFORMATION
Spreadsheet development
VBA - Power BI
  • Development of corporate databases
  • Reports, visualizations, plans, pricelists, budgets...
  • Merging of databases, cleaning, exports
MORE INFORMATION
Recent Comments
  • Dan Paul on SUMMARIZE – groupping in data models (DAX – Power Pivot, Power BI)
  • Haider on LOOKUPVALUE – assigning of values from other table without relation (DAX – Power Pivot, Power BI)
  • namereunused on Remove filter in visuals
  • Anonymous on SUMX vs SUM – key differences very briefly (DAX – Power Pivot, Power BI)
  • jo on SELECTCOLUMNS – select some columns from table (DAX – Power Pivot, Power BI)

ExcelTown - Contact

+420 602 274 999
info@Exceltown.com

Hot news

  • Office Script – how to record script very simply
  • Values ​​/ measures in an Excel pivot table below each other instead of next to each other
  • Keep sorted table for Group By, using Table.Buffer

© exceltown.com / 2020 Vyrobilo studio bARTvisions s.r.o.