Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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. 

1 ACCEPTED SOLUTION
v-yulgu-msft
Employee
Employee

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yulgu-msft
Employee
Employee

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BKirsch12
Resolver II
Resolver II

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.