Forum Discussion
Create fiscal year
Hello everyone,
In Power Query I have a Calendar Table and I want to create a Fiscal Year Column as follows
My year starts from 01/07/N and ends at 30/06/N+1 and in my Fiscal Year Column I want it to display the value "N" meaning the year in which the fiscal year started.
Examples :
Date Fiscal Year
01/09/2020 2020
01/03/2021 2020
01/07/2021 2021
Thanks in advance
Hey Anonymous ,
check the following blog post. It's exactly describing this scenario:
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-2-fiscal-columns
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.bi
1 Reply
- selimovd
Most Valuable Professional
Hey Anonymous ,
check the following blog post. It's exactly describing this scenario:
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-2-fiscal-columns
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.bi