15-05-2020 The Challenge
![DAY 14
Database: AdventureWorksDW2017
Entity: DimCustomer
Instructions:
Select [CustomerKey], [EmailAddress], [EnglishOccupation] and [Yearlylncome] for the customers
whose [BirthDate] was not on a weekend (Saturday, Sunday).](https://www.kiwimaori.nl/wp-content/uploads/2020/05/image-10-1024x325.png)
Birthday not in the weekend
My route
- Build the filter on the BirthDate column, I used Date.DayOfWeekName first, but that was not folding, so I fell back to Date.DayOfWeek
- Needed to find out what number Saturday (1) and Sunday (7) was.
- Removed other columns
- Put the columns in the requested order.
My result
