Days Overnight Count

[CIWEB]

Hello, 

I am trying to modify some of my data to calculate overnights. In this case this is what I have accomplished, using Arrival Date and Departure Date.

Is there a way to remove the the Departure Date from the Date Master? I want to be able to calculate the number of visitors we have by overnights only. The Departure Date does not count towards overnight stays.

Any help or advice would be great.

Thanks

[CIWEB]

Still looking for help with this...

[v-chuncz-msft]

@CIWEB,

You may add step below in the Query Editor.

= Table.SelectRows(Source, each ([Date Master] <> [Departure Date]))

[CIWEB]

Should I be adding that as a new column or  should that be going into the forumla used to get the Master Date?

({ Number.From([Arrival Date])..Number.From([Departure Date]) })?

When I add it as a new column I get an error Expression.Error: The field 'Date Master' of the record wasn't found.