Foreign key

Index column

Primary key

Lookup table

Fact and dimension tables

Active and inactive tables

Qualitative and quantitative data tables

The Data type of the calculated column is Text.

The value of the calculated column is dependent on the Units column.

The formula creates a calculated column named UnitPrice.

The value of the calculated column is dependent on the Revenue column.

Adding a column from examples

Appending queries

Grouping data

Adding an index column

You can create column from the examples that you have defined already

It will list the examples defined by Power BI and you can select anyone to create new column.

When you type 1 or more values in a column, Power BI analyzes if that value matches the data from selected columns or all columns in the table then it will fill remaining column values according to the matched criteria.

Create a bridge table that contains unique values

Join multiple columns of these tables.

Create relationship as normal and select Many to Many cardinality.

The Power BI desktop file opens.

The tile you selected expands and takes the full space

The Power BI desktop file gets downloaded

The report from which the tile was pinned opens.

Fact tables store observations or events while dimension tables contain information about specific entities within the data

Dimension tables tell you about specific roles in Power BI while fact tables tell you information about facts that are associated with those roles in Power BI

Fact tables contain information about specific entities while dimension tables contain information about observational data

There is no difference

Click Share from the upper right of the dashboard you want to share.

Click the ellipsis next to the dashboard name on the Dashboards list, and then click Share.

From your browser, click Share.

From the dashboard list, click share button from actions tab

Waterfall

Gauge

Card

KPI