You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

• A.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.
• B.Add the Weekly_Returns data to the Sales table by using related DAX functions.
• C.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.

Comment: *

Name: *

Email: *

Verification: *

You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.
You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

The related dimension tables are imported into the model.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://finance-bi.com/power-bi-basket-analysis/

Comment: *

Name: *

Email: *

Verification: *

You create the following step by using Power Query Editor.
= Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?

• A.1318
• B.1319
• C.21318 Lasalle Street
• D.21319 Lasalle Street

Correct Answer: D

Explanation
Example:
Replace the text "ur" with the text "or" in the table.

Reference:
https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue

Comment: *

Name: *

Email: *

Verification: *

You have a Microsoft Power Bl dashboard.
You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard.
What should you use?

• A.Feedback
• B.Subscribe
• C.Comments
• D.Mark as favorite

Comment: *

Name: *

Email: *

Verification: *

You have a query that returns the data shown in the following exhibit.

You need to configure the query to display the data as shown in the following exhibit.

Which step should you use in the query?

• A.=Table.ExpandListColum(Table.TransformColunins(Source, {{"classes".
  Splitter.SplitTextByDelimiter('','', QuoteStyle.None), let itemType - (type nullable text) meta
  [Serialized.Text = true] in type {itemType}}}), "classes")
• B.= Table.Unpivot(Source, {"classes"}, "Attribute", "Value")
• C.= Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None),
  {"classes.1"})
• D.= Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})

Correct Answer: B

Explanation
Power Query Unpivot columns: You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.
Chart Description automatically generated

Note:
Syntax: Table.Unpivot(table as table, pivotColumns as list, attributeColumn as text, valueColumn as text) as table Table.Unpivot translates a set of columns in a table into attribute-value pairs, combined with the rest of the values in each row.
Reference:
https://docs.microsoft.com/en-us/power-query/unpivot-column
https://docs.microsoft.com/en-us/powerquery-m/table-unpivot

Comment: *

Name: *

Email: *

Verification: *