Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Вивчайте Relationships, Keys, and Best Practices | Data Modeling and DAX Fundamentals
Power BI for Beginners

Relationships, Keys, and Best Practices

Свайпніть щоб показати меню

A data model is only as good as its relationships. In this chapter, you'll build the connections between all your Summit Gear tables in Power BI's Model View, turning separate tables into a unified, queryable model. You'll learn the difference between primary and foreign keys, how one-to-many relationships work, and why cross-filter direction matters.

1. You drag CustomerID from the Customers table to CustomerID in the Sales table to create a relationship. One customer can have many orders. What type of relationship is this?

2. In a relationship between two tables, what does "cross filter direction: Single" mean?

question mark

You drag CustomerID from the Customers table to CustomerID in the Sales table to create a relationship. One customer can have many orders. What type of relationship is this?

Виберіть правильну відповідь

question mark

In a relationship between two tables, what does "cross filter direction: Single" mean?

Виберіть правильну відповідь

Все було зрозуміло?

Як ми можемо покращити це?

Дякуємо за ваш відгук!

Секція 3. Розділ 2

Запитати АІ

expand

Запитати АІ

ChatGPT

Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат

Секція 3. Розділ 2
some-alt