Thursday, February 20, 2020

Generate Random Numbers in Power Query


Want to create random numbers in Excel? If you're familiar with RAND and the RANDBETWEEN functions, did you know there was an equivalent in Power Query where you can create a list of random numbers in each row. There's no command icon to click in Power Query, so you'll have to go into the M language (but it's fairly easy).

No comments:

Post a Comment