Forum, Tips & Tricks

Learn tips and tricks and engage in discussions with our blog authors here. It’s all for your benefit and learning. 

You need to log in to create posts and topics.

Power Query M - random number

Problem:

Sometimes when you want to try some new features in Power BI, it can be useful to generate "big data sets" with random numbers so that you can mess with them in any way you want without the fear of losing or alternating original data. Is there a possibility to generate random numbers in Power Query  ?

Solution:

Number function:  Number.Random() as number.

·        Returns a random fractional number between 0 and 1