Calendars great, thanks a lot. A great addition is to include business days, FYI while building that I found an error in the calendar. Monday and Sunday are marked as the weekends not Sat/Sun
Excellent video and advice, I opted for Method 3, more complex but needed week numbers to apply to a another table. Also got some good tips on best practice whilst building my data models :)
Nice video - thanks. Best way to create it in your data warehouse 😁 I would love to see a video on using offset (year, month etc) in DAX instead of the built in time int. functions.
i used this "Date.EndOfYear(Date.AddYears(DateTime.Date(DateTime.FixedLocalNow()), 2))" code where "end date" function was the #2 represents years ahead on my table
Avi thnx for all. I encounter a problem with the YTD_flag column. It does not work correct when it compares a leap year with a standard year due to the 29th of February added. Any solution on that?
Calendars great, thanks a lot. A great addition is to include business days, FYI while building that I found an error in the calendar. Monday and Sunday are marked as the weekends not Sat/Sun
Excellent video and advice, I opted for Method 3, more complex but needed week numbers to apply to a another table. Also got some good tips on best practice whilst building my data models :)
Love your videos and resources. Thanks Avi 👍🏻
Nice video - thanks. Best way to create it in your data warehouse 😁
I would love to see a video on using offset (year, month etc) in DAX instead of the built in time int. functions.
How do you extend the calendar for next year for budgeting and forecasting?
i used this "Date.EndOfYear(Date.AddYears(DateTime.Date(DateTime.FixedLocalNow()), 2))"
code where "end date" function was the #2 represents years ahead on my table
Thanks for your calendar and hard work. Great stuff, only addition I had was a Daylight savings time Flag.
Thanks Avi. Great help.
Thanks for your video and the great resource. I have an issue with "there are ambiguous paths between "my table" and "Calendar Table" any ideas?
Hey @Treacle80, send me a message on LinkedIn and I would help you the best I can.
www.linkedin.com/in/PowerBIPro
Power On! / Avi
Avi thnx for all. I encounter a problem with the YTD_flag column. It does not work correct when it compares a leap year with a standard year due to the 29th of February added. Any solution on that?
Also looking for solution to this. Maybe adding Date.IsLeapYear to the power query?