Forum Discussion
Solved
Help with fixed Date
Good afternoon I have the following question: I have a column with the check-out dates of hotel guests and I need to create a new column that always brings me the 15th of the month following the che...
Calculated column:
NextMonth15th = DATE(YEAR([CheckOutDate]), MONTH([CheckOutDate]) + 1, 15)Power Query
= Date.From(Date.AddMonths([CheckOutDate], 1)) + (15 - Date.Day(Date.From(Date.AddMonths([CheckOutDate], 1))))
Easy enough,
= EOMONTH([check-out date],0)+15