Return to Answer

• M is the first step of the process, getting data into the model.

(In PowerBI,) when you right-click on a dataset and select Edit Query, you're working in M (also called Power Query). There's a tip about this in the title bar of the edit window that says Power Query Editor. (but you have to know that M and PowerQuery are essentially the same thing). Also (obviously?) when you click the get data button, this generates M code for you.

• DAX is used in the report pane of PowerBI desktop, and predominantly used to aggregate (slice and dice) the data, add measures etc.

There is a lot of cross over between the two languages (eg you can add columns and merge tables in both) - Some discussion on when to choose which is here and here

• M is the first step of the process: getting data into the model.

In PowerBI, when you right-click on a dataset and select "Edit Query", you're working in M (often called Power Query, which uses M). There's a tip about this in the title bar of the edit window that says "Power Query Editor" (but you would have to know that M and PowerQuery are essentially the same thing). Also when you click the "Get Data" button, this generates M code for you.

• DAX is used in the report pane of PowerBI desktop, and predominantly used to aggregate (slice and dice) the data, add measures etc.

There is a lot of cross over between the two languages (e.g. you can add columns and merge tables in both) - Some discussion on when to choose which is here and here.

• M is the first step of the process, getting data into the model.

(In PowerBI,) when you right-click on a dataset and select Edit Query, you're working in M (also called Power Query). There's a tip about this in the title bar of the edit window that says Power Query Editor. (but you have to know that M and PowerQuery are the same thing). Also (obviously?) when you click the get data button, this generates M code for you.

• DAX is used in the report pane of PowerBI desktop, and predominantly used to aggregate (slice and dice) the data, add measures etc.

There is a lot of cross over between the two languages (eg you can add columns and merge tables in both) - Some discussion on when to choose which is here and here

• M is the first step of the process, getting data into the model.

(In PowerBI,) when you right-click on a dataset and select Edit Query, you're working in M (also called Power Query). There's a tip about this in the title bar of the edit window that says Power Query Editor. (but you have to know that M and PowerQuery are essentially the same thing). Also (obviously?) when you click the get data button, this generates M code for you.

• DAX is used in the report pane of PowerBI desktop, and predominantly used to aggregate (slice and dice) the data, add measures etc.

There is a lot of cross over between the two languages (eg you can add columns and merge tables in both) - Some discussion on when to choose which is here and here

• M is the first step of the process, getting data into the model.

(In PowerBI,) when you right-click on a dataset and select Edit Query, you're working in M (also called Power Query). There's a tip about thi sin the title bar of the edit window that says Power Query Editor. (but you have to know that M and PowerQuery are the same thing). Also (obviously?) when you click the get data button, this generates M code for you.

• DAX is used in the report pane of PowerBI desktop, and predominantly used to aggregate (slice and dice) the data, add measures etc.

There is a lot of cross over between the two languages (eg you can add columns and merge tables in both) - Some discussion on when to choose which is here and here

• M is the first step of the process, getting data into the model.

(In PowerBI,) when you right-click on a dataset and select Edit Query, you're working in M (also called Power Query). There's a tip about this in the title bar of the edit window that says Power Query Editor. (but you have to know that M and PowerQuery are the same thing). Also (obviously?) when you click the get data button, this generates M code for you.

• DAX is used in the report pane of PowerBI desktop, and predominantly used to aggregate (slice and dice) the data, add measures etc.

There is a lot of cross over between the two languages (eg you can add columns and merge tables in both) - Some discussion on when to choose which is here and here