Forum Discussion
How do i create a date table ?
I was trying to create a date table for filtering.. And ran across this DAX (below) ... thinking it looked useful. However when I went to create the table and use it.. Didn't seem to work.. e...
I took GilesWalker's solution (it's great) and modified and added some. The formulas are copy-and-paste ready too (no curvy quote format issues). Here's my preferred finished product:
nchambe - thanks for the feedback and the great write up on your blog.
One change I have made to the formula for creating the table is similar to yours:
DateKey = CALENDAR(DATE(2017,07,01),DATE(YEAR(NOW())+1,06,30))
This way my end date will always move with the changing of calendar years and gives me the date to the end of the financial year.