I am using the Data query provided with the Enterprise DNA program, but looking to add a “Day of Year” or “Julian Date” column. I tried to add the line in the advanced editor, but the new column is not reflecting in the Date query. Is it possible to add a “Day of Year” Column and if so, what is th…

Hi @Jackie , Can you check this code? Thanks let fnDateTable = ( FirstFYDate as date, optional StartOfWeekDay as number, optional AddYears as number, optional Holidays as list ) as table => let FYStartDate = FirstFYDate, // #date(2019, 9, 29), // Enter your first FY StartDate here …

Day of Year Column

Power Query Data Setup

Melissa July 21, 2020, 2:22pm 8

You’re in luck. It just so happens that I answered a question about 13 period fiscal calendars yesterday and created a topic on that, you can find it here.

Can you see if that meets your requirement.