Following Are The Steps For Extracting Date & Time 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 and time values.

Extract Date:

• Go to the "Add Column" tab.

• Click on "Date" and then select "Date Only".

• This will create a new column with the "Date" extracted from your date and time column.

Extract Time:

• Go to the "Add Column" tab.

• Click on "Time" and then select "Time Only".

• This will create a new column with the "Time" extracted from your date and time 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 Date and Time in your dataset.