Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey guys,
I've apparently not found a similar post and kind of been banging my head against the wall about this.
What am I trying to accomplish?
How have I been trying to solve this?
I hope this was not too complicated in explaination, dont know how to solve this at all anymore.
Screenshots:
DimDates
absence_list
Solved! Go to Solution.
Hello,
Generally when I have date intervals of any kind I always try to expand them:
Add a column for the duration:
Then add a list of dates dependant on the start end and duration:
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
Hello,
Generally when I have date intervals of any kind I always try to expand them:
Add a column for the duration:
Then add a list of dates dependant on the start end and duration:
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!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |