Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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. 

2 Replies