* Cantinho Satkeys

Refresh History
  • FELISCUNHA: dgtgtr   49E09B4F  e bom fim de semana   4tj97u<z
    15 de Fevereiro de 2025, 16:34
  • j.s.: tenham um excelente fim de semana  49E09B4F
    14 de Fevereiro de 2025, 17:06
  • j.s.: dgtgtr a todos  4tj97u<z
    14 de Fevereiro de 2025, 17:06
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    14 de Fevereiro de 2025, 11:24
  • cereal killa: ghyt74 pessoal  classic
    14 de Fevereiro de 2025, 10:08
  • JPratas: try65hytr Pessoal  classic k7y8j0 h7ft6l
    14 de Fevereiro de 2025, 03:52
  • JPratas: dgtgtr A Todos  4tj97u<z k7y8j0 yu7gh8
    13 de Fevereiro de 2025, 18:08
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    13 de Fevereiro de 2025, 11:32
  • j.s.: try65hytr a todos  4tj97u<z
    12 de Fevereiro de 2025, 21:00
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana  4tj97u<z
    08 de Fevereiro de 2025, 11:36
  • j.s.: tenham um excelente fim de semana  43e5r6 49E09B4F
    07 de Fevereiro de 2025, 20:23
  • j.s.: try65hytr a todos  4tj97u<z
    07 de Fevereiro de 2025, 20:23
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    07 de Fevereiro de 2025, 11:24
  • JPratas: try65hytr A Todos  4tj97u<z classic k7y8j0
    07 de Fevereiro de 2025, 04:15
  • j.s.: dgtgtr a todos  49E09B4F
    06 de Fevereiro de 2025, 14:24
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    05 de Fevereiro de 2025, 11:33
  • JPratas: try65hytr Pessoal  4tj97u<z classic k7y8j0
    05 de Fevereiro de 2025, 02:35
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana   4tj97u<z
    01 de Fevereiro de 2025, 11:59
  • j.s.: tenham um excelente fim de semana  49E09B4F
    31 de Janeiro de 2025, 21:20
  • j.s.: try65hytr a todos  4tj97u<z
    31 de Janeiro de 2025, 21:20

Autor Tópico: Power Query M Language programming secrets to take you to the next level  (Lida 105 vezes)

0 Membros e 1 Visitante estão a ver este tópico.

Offline mitsumi

  • Moderador Global
  • ***
  • Mensagens: 118061
  • Karma: +0/-0

Power Query M Language programming secrets to take you to the next level
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 1.35 GB
Genre: eLearning Video | Duration: 17 lectures (2 hour) | Language: English

About This Class

In this class, you will learn all the building blocks of Power query M language programming.

You will learn the following topics.

- Introduction to Power query M language

- How to rename & sort columns dynamically

- Secrets of List functions in power query M language

-Group by aggregation in M Formula language

- Error handling

- Secrets of record function in power query M language

- Nested let and variables in M language

- Dynamic table creation

Power Query M language is like an ETL for the data warehouse. It is used to transform the data before loading it into the power bi data model for ongoing data analysis.

You can also use ribbon on power query but it has limited functionalities that are not enough to work freely in data transformation. To overcome the graphical user interface functionalities limitation, you need to learn the Power Query M language.

Whenever we perform any operation on the data inside the power query, the power query generates M code in the background. Power Query M language is also called M formula language or Data mashup language.

If you want to build stunning dashboards in the Power BI, you need to prepare data accordingly and for the preparation of the data, you need to be good in Power Query M language.

In this class, you will learn all the building blocks for power query M language that will develop a solid background, so that you can implement any function in the Power Query M language without any issue.

In the end, I wish you all the best.

Download link:
Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction