Following Are The Steps For Extracting Name Of Day & Name Of Month Into Different Columns

1. Load your data:

• Import your dataset into Power BI.

2. Open Power Query Editor:

• Go to the "Home" tab and click on "Transform Data" to open the Power Query Editor.

Extract Name of Day:

• Select the column that contains your date values.

• Go to the "Add Column" tab.

• Click on "Date" and then select "Day" -> "Name of Day".

• This will create a new column with the name of the day extracted from your date column.

Extract Name of Month:

• With the date column still selected, go to the "Add Column" tab.

• Click on "Date" and then select "Month" -> "Name of Month".

• This will create a new column with the name of the month extracted from your date column.

3. Close and Apply:

Once you have added all the necessary columns, click on "Close & Apply" to apply the changes and return to the main Power BI window.

You should now have separate columns for the name of the day and the name of the month in your dataset.