Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Find articles, guides, information and community news

Most Recent
v-yiruan-msft
Community Support
Community Support

Calculate Row Total and Column Total in Power Query

Read more...

Vijay_A_Verma
Super User
Super User

Power Query doesn't provide List.RandomBetween function. This article provides a way for this.

Read more...

v-jingzhang
Community Support
Community Support

Make column numbering not consecutive over the whole dataset but just for equal column names

Read more...

v-rzhou-msft
Community Support
Community Support

This is an article about how to do cumulative counting by group in Power Query.

Read more...

Vijay_A_Verma
Super User
Super User

This article gives the formula to test whether a given data is Date or not.

Read more...

Vijay_A_Verma
Super User
Super User

This article offers formulas to simulate STARTOFWEEK and ENDOFWEEK functions like Date.StartOfWeek and Date.EndOfWeek functions of Power Query language M

Read more...

TedPattison
Employee
Employee

Join us for the May session of Power BI Dev Camp with Alex Powers of the Power BI CAT team. Alex will teach you how to get started with creating custom functions to aid in the reusability of transformation patterns and how to add robust documentation to your Power Query queries.

Read more...

Vijay_A_Verma
Super User
Super User

This article provides formulas for Text.ContainsAny and Text.ContainsAll functions as these are not provided by Power Query Language M.

Read more...

Vijay_A_Verma
Super User
Super User

This article gives a formula to generate integer random numbers in Power Query Language M.

Read more...

Vijay_A_Verma
Super User
Super User

This gives you two formulas to test whether a value contained is number or not. 

Read more...

Vijay_A_Verma
Super User
Super User

Use Case - Excel offers many number conversion functions and BIN2DEC (Binary to Decimal) is one of them. But Power Query's M language doesn't offer this conversion function. Below are some examples when a binary number is given and Excel's BIN2DEC function is applied on that. 

Read more...

Vijay_A_Verma
Super User
Super User

Use Case - Sometimes there will be a need to extract domain names from given URLs. Hence http://www.microsoft.com should give microsoft. Below are some sample cases and the results expected.

domain.png

Read more...

amitchandak
Super User
Super User

How to perform a ‘split and merge’ on columns to change (a) into (b)?

 

Power BI(67).png

Read more...

Vijay_A_Verma
Super User
Super User

Use Case - There are scenarios where you will be required to find the first/last non null value in a row. For example, to answer the questions:

1. What was the first sales amount done by a sales person? - This means that you will have to find first non-null from 2017 to 2022. For example, for Greg this is 688.

2. What was the last sales amount done by a sales person - This means that you will have to find last non-null from 2017 to 2022. Hence for Laura, this is 753.

Of course, if more years are added in the beginning or end, the formula should support the flexibility of Power Query i.e. if more columns are added, the result should include those columns as well.

Read more...

Vijay_A_Verma
Super User
Super User

Use case - Somebody asked me if the cell is not showing complete content then how he can see the complete content of a cell and copy the cell content from there.  You know something is there as at the end as ... (3 dots) will be there when you see the cell content.

I believe this problem many may be facing, hence it is worthwhile to share the tip here.

Basically, I had advised the person how to see SQL statement when Query folding is happening. And he wanted to copy the SQL statement but display was not showing complete SQL statement.

Read more...

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.