Filter only revenues from home reservations at month-closed including cancelled reservations.

Hi everyone. Just wanted some help. I am stuck on my table generated from our guest billing system where I download reservations on a given closed month and calculate the revenue for the month. The table includes reservations that cancelled within the month but I only have to include those with revenue. At first, I tried Power Query: duplicating the original table and filter the duplicate copy based on those have values in Cancellation Date column. Then I grouped Itinerary Item ID and the Total columns to show cancelled reservations with revenue. Then I merged the filtered duplicate copy with the original table and that's where am stuck after. How to put this in power query where I include only home reservations and those cancelled reservations during the month? Hope someone helps me.