Power BI Quizzes

Practice Quizzes
Thanks!
Thanks!

Power BI Quizzes

Accelerate your Career and Get Certified

Use relationships effectively

Wednesday, April 7th, 2021

Welcome to your Use relationships effectively

Questions are based on this module

The solid line between the two tables indicates that it is _______ relationship.

an inactive

the active

The dashed line between the two tables indicates that it is _______ relationship.

an inactive

the active

An inactive relationship will never be used unless ________.

Explicitly declared in a measure

Both fields in the active relationship are added to the view

Both fields in the relationship are added to the view

This function

Sales by Ship Date = CALCULATE(Sales[TotalPrice], USERELATIONSHIP('Calendar'[Date], Sales[ShipDate]))

Allows total price to be calculated using the inactive relationship between 'Calendar'[Date] and Sales[ShipDate]

Creates an active relationship between ShipDate and the calendar date

Time is Up!

Time's up

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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

© Learning Tableau. All rights reserved.
Privacy Policy | Design by Liscio Apps, LLC