Add Fiscal Year + Fiscal Month to Date table Query

[Melissa]

Hi @Ikay,

That depends on how you declare the FYStartMonth parameter, what other filter context is coming in but more importantly what attributes you’ve selected from the Date table…

Below I’ve set the FYStartMonth as April

.

Just grab the M code from here and explore for a bit.

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…

I hope this is helpful.