cancel
Showing results for 
Search instead for 
Did you mean: 

Challenge #4 Filter Transactions data by the business days

Rasha
Employee
Employee

In this Challenge, we need to get the dates of the business days

based on the data of :

  1. Calendar Dimension Data
  2. Public holidays 

The result should be like that:

Screenshot 2023-01-03 at 5.00.52 PM.png

 

2 REPLIES 2

LukeG
Employee
Employee

Here is my solution demo!

https://youtu.be/dWhTLDDX9yE

zhong
Partner
Partner

challenge#4.png

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.  Screenshot 2023-03-28 122543.png

Screenshot 2023-03-28 123736.png