Microsoft Certified: Power BI Data Analyst Associate PL-300 Book

In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.

Add the Weekly_Returns data to the Sales table by using related DAX functions.

Create a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.

an additional date table named ShipDate, a one-to-many relationship from

Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from

Sales[sales_ship_date_id] to ShipDate[date_id]

an additional date table named ShipDate, a many-to-many relationship from

Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from

Sales[sales_ship_date_id] to ShipDate[date_id]

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]

a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many

relationship from Sales[sales_ship_date_id] to Date[date_id]

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]

import that uses a Microsoft account

DirectQuery that uses the end-user s credentials

DirectQuery that uses a database credential

Import that uses a database credential