Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Still looking for help with this...
You may add step below in the Query Editor.
= Table.SelectRows(Source, each ([Date Master] <> [Departure Date]))
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |