Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |