A data sheet consists of the Date column in the format ‘YY/mm/dd’. If you want to get the Month name from the field Date, which of the following operations must have?1) In Power Query, select the ‘Date’ column2) From the [Add Column] tab on the ribbon, select [Custom Column]3) From the [Add Column] tab on the ribbon, select [Column From Examples] commend and then select [From Selection]4) In the new appeared column, select [Month Name]Question 13Select one:a.1,3,4b.1,2,3c.1,2,3,4d.2,3,4

You have a dataset that includes a column with dates in the format "DD/MM/YYYY". You want to create a new column that only includes the year of the date. Which expression should you use in the Custom Column feature of Power Query?

. How do you get Power BI to separate date data into year, quarter, month, and day? Open the Query EditorSelect the New Parameter buttonSelect the New Measure button

Which of the following functions returns only the month from a given date in Excel?Answer( Please choose a correct answer )   CLEARDAY()YEAR()MONTH()DATE()

Which of the following is not a valid date extract option in Tableau?Question 1Answera.Monthb.Quarterc.Weekd.Year

Which of the following methods are used to spilt columns in Power Query?1) by delimiter2) by number of characters3) by positions4) by lowercase to uppercaseQuestion 17Select one:a.1,4b.1,2,3,4c.2,3,4d.1,2,3