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
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.