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.
Hello,
I am using a calendar table and would like to make the end date to be current year plus 1. I am using the following formula in the query editor: =Date.EndOfYear(DateTime.Date(DateTime.FixedLocalNow())). This is giving me the end date for the current year. I would like the end date for the next calendar year. How can I adjust this formula to give me that result.
Thanks for your help!
Solved! Go to Solution.
Date.AddYears(Date.EndOfYear(DateTime.Date(DateTime.FixedLocalNow())),1)
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Something like this?
=DateTime.Date(#datetime(Date.Year(DateTime.FixedLocalNow())+1, 12,31)
Usually I create my data tables in DAX, not PowerQuery but this might be what you are looking for 🙂
Proud to be a Super User!
Date.AddYears(Date.EndOfYear(DateTime.Date(DateTime.FixedLocalNow())),1)
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Thank you! This works perfectly. I can also adjust the number of years if needed. I was hving trouble figuring out where to put the number of years, I kept adding "+1" instead of just the "1".
I've found this method for creating a calendar table to be more flexible. A little bit longer to set up, but it can probably help you here.
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |