https://community.incorta.com/t5/incorta-conundrums/challenge-4-filter-transactions-data-by-the-business-days/m-p/3903#M21 <P>Here is my solution demo!</P> <P><A href="https://youtu.be/dWhTLDDX9yE" target="_blank">https://youtu.be/dWhTLDDX9yE</A></P> Wed, 15 Mar 2023 18:34:54 GMT LukeG 2023-03-15T18:34:54Z https://community.incorta.com/t5/incorta-conundrums/challenge-4-filter-transactions-data-by-the-business-days/m-p/3522#M10 <P>In this Challenge, we need to get the dates of&nbsp;the business days</P> <P>based on the data of :</P> <OL> <LI>Calendar Dimension Data</LI> <LI>Public holidays&nbsp;</LI> </OL> <P>The result should be like that:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2023-01-03 at 5.00.52 PM.png" style="width: 999px;"><img src="https://community.incorta.com/t5/image/serverpage/image-id/1842iB4857F19EB79E72D/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2023-01-03 at 5.00.52 PM.png" alt="Screenshot 2023-01-03 at 5.00.52 PM.png" /></span></P> <P>&nbsp;</P> Tue, 03 Jan 2023 15:03:31 GMT https://community.incorta.com/t5/incorta-conundrums/challenge-4-filter-transactions-data-by-the-business-days/m-p/3522#M10 Rasha 2023-01-03T15:03:31Z https://community.incorta.com/t5/incorta-conundrums/challenge-4-filter-transactions-data-by-the-business-days/m-p/3903#M21 <P>Here is my solution demo!</P> <P><A href="https://youtu.be/dWhTLDDX9yE" target="_blank">https://youtu.be/dWhTLDDX9yE</A></P> Wed, 15 Mar 2023 18:34:54 GMT https://community.incorta.com/t5/incorta-conundrums/challenge-4-filter-transactions-data-by-the-business-days/m-p/3903#M21 LukeG 2023-03-15T18:34:54Z https://community.incorta.com/t5/incorta-conundrums/challenge-4-filter-transactions-data-by-the-business-days/m-p/3973#M27 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="challenge#4.png" style="width: 999px;"><img src="https://community.incorta.com/t5/image/serverpage/image-id/2053i9E14492A6B2E92B9/image-size/large?v=v2&amp;px=999" role="button" title="challenge#4.png" alt="challenge#4.png" /></span></P><P>My result is a bit different, the total business day count is 249. Found out the WorkingDay column in CalendarDimension may be not robust.&nbsp; 5/3/2021 is not PH day or Weekends.&nbsp;&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2023-03-28 122543.png" style="width: 999px;"><img src="https://community.incorta.com/t5/image/serverpage/image-id/2052iAB0F236EFD6F1BE0/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2023-03-28 122543.png" alt="Screenshot 2023-03-28 122543.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2023-03-28 123736.png" style="width: 999px;"><img src="https://community.incorta.com/t5/image/serverpage/image-id/2054iC4EDDA5A63686337/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2023-03-28 123736.png" alt="Screenshot 2023-03-28 123736.png" /></span></P> Tue, 28 Mar 2023 16:39:08 GMT https://community.incorta.com/t5/incorta-conundrums/challenge-4-filter-transactions-data-by-the-business-days/m-p/3973#M27 zhong 2023-03-28T16:39:08Z