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

Join us at the 2025 Microsoft Fabric Community Conference. March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for $400 discount. Register now

Find articles, guides, information and community news

Most Recent
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

Use Case: There are many scenarios where we are required to extract the integer portion of a number.

Hence, for 23.57 and for -45.678, the integer portions will be 23 and -45 respectively. 

Power Query Number functions library doesn't provide any function which can do this. Hence, we will work out a formula to make a Number.Int function.

Read more...

Helpful resources

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