Forum Discussion
Devtr
Helper III
Helper IIIGroup the column based on two date columns
Hello teachers. I have some hotel data for future reservations. All the reservations have rate categories, rate, check-in date, check-out date, and other fields. I wanted to compare past reservati...
HI Devtr,
It sounds like a common multiple date fields analysis requirement, you can take a look at Greg's blog 'start date', 'end date' parts if it helps:
Regards,
Xiaoxin Sheng
DevtrHelper III
Helper IIII made the row data as monthly. I added few additional columns in power query. And resolved the issue. Thanks though.