Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Power BI Power Query: Function to start from a Set date.

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))

Objekt_0-1643210533162.png


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.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , Add +6 to this formula or AA?

Number.Mod([Index],30)+6

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , Add +6 to this formula or AA?

Number.Mod([Index],30)+6

Anonymous
Not applicable

Thanks @amitchandak worked after adding it to [Index]

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.