Forum Discussion
undefined
I have a date column like the below screenshot by using the date column I want to create fiscal week, fiscal Quarter, fiscal Month. Can you show me the DAX Query
Hi Anonymous ,
what is the offset from the fiscal year?
By the way, there is a very comprehensive DAX date template from SQLBI, maybe it's worth taking a look.
https://www.sqlbi.com/tools/dax-date-template/
2 Replies
Hi Anonymous ,
what is the offset from the fiscal year?
By the way, there is a very comprehensive DAX date template from SQLBI, maybe it's worth taking a look.
https://www.sqlbi.com/tools/dax-date-template/
Hi Anonymous ,
EnterpriseDNA has the date table provided with the fiscal details.
You just need to set your FY start month
Here's the link, you can download the pack and you're good to go.
https://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
Hope this helps!
