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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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.