Forum Discussion

dbrandone's avatar
dbrandone
Icon for Helper IV rankHelper 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
Icon for Super User rankSuper 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
Icon for Helper IV rankHelper IV
5 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
    Icon for Super User rankSuper User
    5 years ago

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