Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to create a Fiscal Calendar with Columns:
I've tried several tutorials but they don't seem to tally with my 2023 Fiscal Calendar.
Attached picture above shows October 30, 2022 as Fiscal Year 2022, Fiscal Quarter 4, Fiscal Month 12 instead of 2023, 1, 1, respectively.
October 30 should be the starting date with October 28 as ending date of Fiscal Year 2023.
Solved! Go to Solution.
Hi @Anonymous,
See attached PBIX. Review the Power Query code and let me know if you have any questions.
Original code from @mahoneypat I think.
Modified to suit my application.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Hi @Anonymous,
See attached PBIX. Review the Power Query code and let me know if you have any questions.
Original code from @mahoneypat I think.
Modified to suit my application.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Sorry, I rushed the reply and PBIX.
I called the main query Date, the query is usually called Fiscal in my Date Dataflow and I merge it with the main Date table, on date. Then expand what you need.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |