Learn Power BI

Blog
Practice Questions

Learn Power BI

Accelerate your Career and Get Certified

Date table

Saturday, April 3rd, 2021

Welcome to your Create a Date table

Questions are based on this module

This function returns a complete range of dates that are automatically determined from your dataset

CALENDARAUTO()

CALENDAR()

DATERRANGE()

DATERANGEAUTO()

Benefits of a date table include [select all that apply]

determining days between two dates, such as order date and ship date

determining whether a given date is a company holiday

determining the fiscal year of a given date

determining the calendar year of a given date

A date table must contain a column of type 'date' with unique values.

False

True

A date table is any table containing a date range in one of the columns. There is no 'official' date table in Power BI.

True

False

Time is Up!

Time's up

Leave a Reply Cancel reply

Your email address will not be published.

Comment

Name

Email

Website

Δ

About the Author: Lukas Halim

I earned a Masters in Analytics from NC State in 2013 and now work as a data analyst in the health insurance industry. Using tools such as SAS, Tableau, and Teradata, I conduct analysis to help my company improve healthcare affordability and customer engagement.

Learn More

4.6 Instructor Rating
53,604 Students

14,612 Reviews
2 courses

© Power Bi Skills. All rights reserved.
Privacy Policy | Design by Liscio Apps, LLC