Top "M" questions

The M Modelling Language was a component of Microsoft's "Oslo" project, later known as SQL Server Modeling CTP.

how to convert a Integer to Text value in Power BI

I am creating a calculated column in existing power BI report. the calculated column concatenates integer & text columns. I …

sql powerbi dax m
How can I reference a cell's value in PowerQuery

I'm having multiple PowerQuery queries that I would like to feed the value of a cell in my Excel file. …

excel parameter-passing powerquery m
What is the M language for?

I heard Microsoft developed a programming language called M. Can someone explain the use of M and how a C# …

m
What's the difference between DAX and Power Query (or M)?

I have been working on Power BI for a while now and I often get confused when I browse through …

powerbi dax powerquery m
How to Do Countifs/Sumifs in PowerQuery M.Language Formulas?

Is it possible to Do Excel's Countifs/Sumifs formulas in powerquery Formulas? Let's Say I have [Column1] as "Criteria range" …

powerbi powerquery m
How do I comment in Power Query M?

Is there a way to comment M code / comment out lines or blocks of code?

comments powerquery m
How to set a max run time / timeout for Power Query?

Is there a way to set a max run time or a timeout factor in Power Query so that after …

excel timeout powerquery m
Select row with MAX value per category Power BI

How to select row with max value per category in M of Power BI. Suppose we have table: +----------+-------+…

powerbi powerquery m
PowerQuery: How can I concatenate grouped values?

If I have the following table (shown in the image below), how can I write a grouped query that would …

excel group-by powerquery excel-2016 m
Concatenate text with newlines in PowerBI

If I have a column in a table where each cell contains text, how can I push them as output …

powerbi dax m