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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. 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.