Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
I do a power query to a local database, and now I need to add a new column with a cyclic number sequence. I need to do this in Power Bi.
The column should start with 1 and go up to 93 and then start over.
Please advise.
BR
Solved! Go to Solution.
Hi @Frigge__ ,
First, go to the Add Column tab in Power Query > Index Column > From 0.
Then add another custom column like this:
Number.Mod([Index], 93) + 1
Pete
Proud to be a Datanaut!
Hi @Frigge__ ,
First, go to the Add Column tab in Power Query > Index Column > From 0.
Then add another custom column like this:
Number.Mod([Index], 93) + 1
Pete
Proud to be a Datanaut!