Forum Discussion
Calculate average rate on days between dates
I have a table called “Rates”, which contain rows of rental rates for specific sets of dates. Each row has a column for the “Nightly rate” as well as the “dates From” and “Dates To”. This is a bas...
olgad
Resident Rockstar
Resident RockstarHi, create another custom column for the previous date of the Date To column
Date.AddDays([Date To Column],-1)
and then plug it into the function that i shared with you.
the function creates numbers per row.
from this table
So, it shall work as you expect.
to this table:
Hi olgad Thanks very much! We are going to test this then hopefully we can Accept Solution. Thanks v much for your help. Thanks