Fiscal Year -> Calendar Year

[BrianJ]

@VBA,

Welcome to the forum – great to have you here!

If you use the Extended Date Table code created by @Melissa, it automatically creates the FY and FM columns for you, based on an initial parameter you supply indicating what month your fiscal year starts in:

Extended Date Table (Power Query M function)

Hi everyone, To make it easier to find I’ve placed the updated Power Query M code function for the extended Date Table / Dates Table in the category where it belongs… I hope you’ll find it useful and if there are any questions, just reach out and let me know! // August 2022 There has been an overhaul of the M code from when it was initially shared. This affects column names and values. In the Analyst Hub (follow this link) you can copy a version of Extended Date table which returns a r…

She and I have actually done an entire time intelligence video series on how to fully leverage the power of this extended date table.

Time Intelligence series by BrianJ and Melissa

Hi everyone, We’ve brought the Time Intelligence series we did for Enterprise DNA TV together in this post so it’ll be easier to find and navigate through completely. @BrianJ and I had great fun doing these. If you have any questions or concerns about the content covered in these video’s please create a new topic, refer to the video and @mention BrianJ or Melissa. But we’d also welcome your feedback within this thread of course. – THANK YOU – How to create a Holiday table [Ho…

I hope this is helpful.

• Brian