Codepedia
  • My coding farm
  • Microsoft Excel
  • Macro-VBA
  • Power Query & M
  • Data Model & DAX
  • Microsoft Power BI
  • Tableau
  • SQL
  • SQL Server BI (Microsoft BI)
  • R Programming
  • Python
  • stackoverflow
Powered by GitBook
On this page

Power Query & M

https://trello.com/b/9fdNDGbV/powerquery-m-mashup-programming-wiki-cevi

What is Power Query?

What is M language?

________________________________________________________________________________

  • ​Working with Web Services in Power Query

  • Introduction to Data Mash-up Engine of Power BI

  • Intro to M language in Excel & Power BI​

  • ​Power Query, mehrere Werte in einer Zelle verketten​

  • ​Entpivotieren von Spalten (Power Query)​

  • ​Operators​

  • ​PowerQuery: How can I concatenate grouped values​

  • ​Multi Condition Logic In Power Query​

  • ​Date.ToText​

  • ​Date functions​

  • ​Power Query M Reference​

  • ​ IF Statement using Power Query​

  • Append & Merge

  • Text functions

  • Text Extraction with M Language

  • Rounding Numbers Complete Menu

  • Mathematical Formulas

    • Advanced

    • Simple

  • Machine learning development training in Power BI M language

  • Choose the Right Merge Join Type in Power BI

  • M or DAX?

  • Append vs. Merge

  • Custom Functions Made Easy in Power BI Desktop

  • Warning! Misleading Power Query Filtering

  • Do You Need a Date Dimension?

  • #shared & #sections : Get List of Queries in Power BI

  • Calculation Error, Infinity, NaN, Null, & check anomalies

  • Power Query Not for BI: Part1, Part2, Part3

  • Pivot and Unpivot

  • Fetch Files and/or Folders with Filtering and Masking: Power Query

  • Joining Types in Power BI

  • The Complete Guide to Installing Power Query

  • Dynamic Calendar Table

  • Query Folding

  • Date from Text

PreviousMacro-VBANextData Model & DAX

Last updated 6 years ago