Forum Discussion

CIWEB's avatar
CIWEB
Helper I
7 years ago

Days Overnight Count

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

Need Help
Show and Tell

3 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    7 years ago

    CIWEB,

     

    You may add step below in the Query Editor.

    = Table.SelectRows(Source, each ([Date Master] <> [Departure Date]))
    • CIWEB's avatar
      CIWEB
      Helper I
      7 years ago

      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.