Example: Calculate with records

Demystifying M in Power Query

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

Example: Calendar table – Revisited

Demystifying M in Power Query

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

Example: Get value from a cell – Revisited

Demystifying M in Power Query

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

Example: Reference intermediary steps

Demystifying M in Power Query

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

Exercises – Record values

Demystifying M in Power Query

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

Records, lists and tables

Demystifying M in Power Query

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

Records and let & in statements

Demystifying M in Power Query

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

Record functions

Demystifying M in Power Query

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

Accessing record values

Demystifying M in Power Query

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.

Record values

Demystifying M in Power Query

It looks like you don’t have access to this page This content is available to full Excel Academy members only. You are not currently logged in. Log in here: Login If you think this is a mistake, please contact support. To get access, join the Excel Academy today.