Following Are The Steps For Extracting Year-Quarter-Month-Day 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.

3. Add Custom Columns:

• In the Power Query Editor, select the column that contains your date values.

Extract Year:

• Go to the "Add Column" tab.

• Click on "Date" and then select "Year" -> "Year".

• This will create a new column with the year extracted from your date column.

Extract Quarter:

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

• Click on "Date" and then select "Quarter" -> "Quarter".

• This will create a new column with the quarter extracted from your date column.

Extract Month:

• Again, with the date column selected, go to the "Add Column" tab.

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

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

Extract Day:

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

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

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

4. 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 Year, Quarter, Month, and Day in your dataset.