Challenge #4 Filter Transactions data by the business days
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-03-2023 07:03 AM
In this Challenge, we need to get the dates of the business days
based on the data of :
- Calendar Dimension Data
- Public holidays
The result should be like that:
Labels:
- Labels:
-
Business Logic
-
Intermediate
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-15-2023 11:32 AM - edited ‎03-15-2023 11:34 AM
Here is my solution demo!
This video demonstrates how to solve the fourth challenge on the Incorta Community.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-28-2023 09:39 AM
My result is a bit different, the total business day count is 249. Found out the WorkingDay column in CalendarDimension may be not robust. 5/3/2021 is not PH day or Weekends.
