Date Table Example

Lee Grisham

Does anyone have a copy of the date table text file from the bbdevdays in 2021? I'm trying to recreate that table with FY information and the link is now broken…

Or if there is another example you could share, much appreciated!

Austen Brown

@Lee Grisham - What presentation was this apart of?

Lee Grisham

@Austen Brown

Austen Brown

@Heather McLean - Is this something you can help track down?

Carol Grant

@Lee Grisham- I have used the website Radacad to get the Date Table script. They have FY information in there. This is for use in Power Query.

Or this blog about Dates in DAX

I hope this helps!

Carolyn Grant

Middlebury College

Middlebury VT

Rebecca Sundquist

Hello, @Lee Grisham! There are many great resources online for Date table set-up. One thing I found missing was the ability to dynamically set the start and end of the date range. I added this template to the community today:

https://community.blackbaud.com/forums/viewtopic/586/64143