Solved: Re: undefined

Anonymous · ‎08-28-2020

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

mwegener · ‎08-28-2020

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/

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials

View solution in original post

mussaenda · ‎08-28-2020

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!

mwegener · ‎08-28-2020

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/

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials