Need a column that captures current row data and next row data

[Melissa]

Hi @wweber,

If this is what you are after, that should be easy!

Just get the Basic Date table function from here and copy that full script into a New Blank Query.

Basic Date Table (Power Query M function)

Hi all, There have been requests for a basic Date table that includes week logic centered around the start- / end of week dates AND/OR fiscal weeks. Both will start on the selected Start of week day but the first creates weeks of 7 days when crossing over into the next calendar year and the second weeks with <= 7 days around each fiscal year start and -enddate, as illustrated below. . [image] . Copy this M code script into a new blank query. let fnDateTable = (StartDate as date, EndDate …

.
Always invoke the Date table for full years (that can be either calender OR fiscal) and set your FYStartMonthNum to November to achieve the above result (at the Day level).

There’s also an ISO-8601 equavalent of this Date table called the Extended Date table, you can find that in the M Code Showcase category OR click on my Badge that has a direct link to that topic as well.

I hope this is helpful.