Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
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
This whole video is great.
Link is at the time he shows the formulas to make different type of date fields.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |