Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I'm sure this is pretty easy but I'm not too familiar with Power Query.
Below I have two Columns
- Index which starts from 0
- AA - This counts from 0 to 29 and then repeats every 30 rows. This starts from '0' in the Index column.
AA- = Table.AddColumn(#"Added Index", "AA", each Number.Mod([Index],30))
What I want to do is create a new column the exact same as AA but with the counting starting from 5 in the index column instead of 0.
I've had a look around but nothing has helped so far.
Thanks in Advance.
Solved! Go to Solution.
@Anonymous , Add +6 to this formula or AA?
Number.Mod([Index],30)+6
@Anonymous , Add +6 to this formula or AA?
Number.Mod([Index],30)+6
User | Count |
---|---|
139 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |