Forum Discussion
Filter DatesBetween
Hello,
Generally when I have date intervals of any kind I always try to expand them:
Starting table
Add a column for the duration:
[End]-[Start]
Then add a list of dates dependant on the start end and duration:List.Dates([Start],[Duration]+1,#duration(1, 0, 0, 0))
Expand the list and you have a row for each day of each interval:
By taking this approach you should always get the exact number of days as each row can be individually counted!
Hope this helps!
Br,
J
Community ChampionHello,
Generally when I have date intervals of any kind I always try to expand them:
Starting table
Add a column for the duration:
[End]-[Start]
Then add a list of dates dependant on the start end and duration:
List.Dates([Start],[Duration]+1,#duration(1, 0, 0, 0))
Expand the list and you have a row for each day of each interval:
By taking this approach you should always get the exact number of days as each row can be individually counted!
Hope this helps!
Br,
J
Thank you very much!
I'll mark as solution as soon as I've tested out!