Forum Discussion

powertechbi's avatar
powertechbi
Frequent Visitor
1 year ago
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...
Need Help
  • Kaviraj11's avatar
    Kaviraj11
    1 year ago

    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))))
Kaviraj11's avatar
Kaviraj11
Solution Sage
1 year ago

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