migueesc123 / calendarcreator4powerbi Goto Github PK

Hi there firstly this connector is really great and I think that it can only get better with time.

What I have found is that when I have been creating a date table there are two additional things that helps define the date table.

1. Is the ability for the end user to decide when the Date table will end. It could be the end of the current year, or 4 years in advance. With the refreshing of the Date table via the Query Editor, this can change on each and every refresh.

2. Also the capability to be able to define when the Fiscal Month starts. As here in Australia it starts from the 7th month, whilst when I was living in South Africa it was the 3rd month.

Fortunately I have had a blog post in which I have got the M-Code in which I have the parameter for the Fiscal Start Month, which it then uses to calculate the Fiscal Month numbers, Fiscal Years, etc.

As well as the code for when I want my Date table to end.

You can find it here: https://www.fourmoo.com/2016/09/13/power-bi-how-to-easily-create-dynamic-date-tabledimension-with-fiscal-attributes-using-power-query/

If you have any questions please let me know, happy to assist.

Regards
Gilbert