Business Intelligence with Microsoft Power BI - with Material - Extracting the Date and Time

Business Intelligence with Microsoft Power BI - with Material - Extracting the Date and Time

Assessment

Interactive Video

Information Technology (IT), Architecture, Health Sciences, Social Studies, Biology

University

Hard

Created by

Quizizz Content

FREE Resource

This video tutorial demonstrates how to use Power Query to extract date or time from a date and time column. It covers the steps to extract either date or time separately and how to remove unnecessary columns after extraction. The tutorial emphasizes the simplicity of using Power Query for these tasks, highlighting the ease of performing these actions with just a few clicks.

Read more

2 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

Explain how the data type is affected when extracting date or time from a column.

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What can you do if you no longer require the date and time column after extraction?

Evaluate responses using AI:

OFF