How to create a date table as a calculated table in PowerBI itself using DAX?

[Anonymous]

Hi,

I am trying to learn PowerBI and I am into Dax a bit now but part of my assignment I have to write a calculated date table in PowerBI with following fields: Day, Year, Month, month Number, year month number, fiscal year, fiscal quarter, fiscal month no, fiscal week no. I referred this article and got a good start: https://www.sqlbi.com/articles/using-generate-and-row-instead-of-addcolumns-in-dax/

How would I add fiscal year, fiscal month name, fiscal month no, fiscal week no, calendar year in the above approach. The fiscal period starts October 1st and ends September 30th. 

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Here are some similar examples for your reference:

Custom Fiscal Year, Fiscal Quarter and Fiscal Month

Creating a Fiscal Year & Fiscal Quarter in a DATE calendar

Best regards,

Yuliana Gu

[BKirsch12]

This whole video is great.

Link is at the time he shows the formulas to make different type of date fields.

https://youtu.be/RiHpkN0gfPM?t=2712