Forum Discussion

dbrandone's avatar
dbrandone
Helper IV
5 years ago

Date Table Power Query adjustment for End Date

Hi Everyone,    I have the below power query running my date table. I am pulling the start date from a specific column in the data and it happens to be 1/1/2018 which is good, but I set it up where...
Need Help
lbendlin's avatar
lbendlin
Super User
5 years ago

Keep in mind that fiscal years often do not end on 12/31. So no, it's not required. But it won't hurt either.

dbrandone's avatar
dbrandone
Helper IV
4 years ago

lbendlin 

so do you know of anything I can add to the List.Max function for end date that will take my max date and take it to the last calendar date of the max year from my column?

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    If your fact dates are clean (no crazy dates) then CALENDARAUTO() will give you that for free.