Business Intelligence with Microsoft Power BI - with Material - Month and Day Name

The video tutorial explains how to use Power Query in Power BI to find and extract the names of days and months from a date column. It covers setting the correct data type, using the date and day options to get full names, and extracting the first three characters of these names using the transform tab.

What is the first step to find the name of the day in Power Query?

• Load the table and set the column data type to text

• Load the table and set the column data type to date

• Load the table and set the column data type to number

• Load the table and set the column data type to boolean

Which of the following is NOT available in Power Query for date extraction?

• Name of the day

• Name of the day and month

• Name of the month

• Name of the year

How can you extract the first three characters of a month name in Power Query?

• By using the transform tab and extract first characters

• By using the data tab and filter option

• By using the add column tab

• By using the view tab and sort option

What is the purpose of the transform menu in Power Query?

• To load new data into the table

• To change the data type of a column

• To extract specific characters from text

• To delete columns from the table

What should you type in the extract first characters option to get the first three characters?

• Five

• Four

• Three

• Two