To generate integer random values using M first add an index column and then create a custom column using Int16FromNumberRandomBetween1100. In the formula section you can write a formula as Index1. Currently we enter these BSS numbers manually into the a Single Line of Text column when we add a new item to this list however this is kind of inneficient as we first have to go through the list to find the newest item so we can see what the last number used was so going forward Id like it to try and automate it so when a new item is added the BSS number would just increment upwards 1 from the last entered BSS number IE if the last item had a BSS of BSS-50 then the next item would.
This technique can be applied to other scenarios where you have a sequence of events that are local to a particular entity in this case the customer but it could have been the product the session in a log file etc.
In the formula section you can write a formula as Index1. Published on March 23 2018In this video we learn to generate a series in Power BI using the PowerBI DAX- Generate series functionWe then use the generate. CALCULATE COUNTROWS Filter values Table1 Name EARLIER Table1 Name Table1 Name But this does drive off the distinct values in the name column and gives them an sequence based on their alphabetic order. Using-power-query Question 14 182019 85417 PM 1182019 74306 PM Microsoft Power Query for Excel enhances self-service BI for Excel with an intuitive and consistent experience for discovering combining.