Using Power Query M Code to create a Fiscal Calendar in Visual Studio

[Anonymous]

HI,

I am trying to create a Fiscal Calendar in Power BI, we are using Direct Query and my Calendar is written in M code. I cannot create it in Visual Studio for Analysis services as there is no underlying Data Source. I have been trying to append my M code (for the Calander) into the M code for a Date Dimension Object.

Any help with trying to merge the two so I can use my Calendar in Power BI Reports?

Or any other way to create a Fiscal calander in Visual Studio /Analysis services.

tia

[v-yanjiang-msft]

Hi @Anonymous ,

Please see if this document can help:

How to: Programmatically create a custom calendar - Visual Studio (Windows) | Microsoft Learn

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.