Power BI workflow (get data, transform, visualize, share) - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to load data from a CSV file in Power BI.

Power BI

let Source = Csv.Document(File.Contents([1]),[Delimiter=",", Columns=5, Encoding=1252, QuoteStyle=QuoteStyle.None]) in Source

Drag options to blanks, or click blank then click option'

A"data.csv"

Bdata.csv

CFile.Load("data.csv")

DLoad("data.csv")

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around the file name.

Using incorrect functions to load the file.

In Power Query M language, file paths must be given as text strings with quotes, so "data.csv" is correct.

2fill in blank

medium

Complete the code to rename a column in Power Query.

Power BI

Table.RenameColumns(Source, [1])

Drag options to blanks, or click blank then click option'

A{"OldName", "NewName"}

B["OldName" = "NewName"]

C{{"OldName", "NewName"}}

D[{"OldName", "NewName"}]

Attempts:

3 left

💡 Hint

Common Mistakes

Using curly braces incorrectly.

Using square brackets instead of curly braces.

Table.RenameColumns expects a list of pairs inside double curly braces, so {{"OldName", "NewName"}} is correct.

3fill in blank

hard

Fix the error in the DAX measure to calculate total sales.

Power BI

Total Sales = SUM([1][SalesAmount])

Drag options to blanks, or click blank then click option'

AOrder

BOrders

CSales

DSalesData

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect or partial table names.

Misspelling the table name.

The table name must match the data model exactly. 'Orders' is the correct table name containing SalesAmount.

4fill in blank

hard

Fill the blank to filter sales data for the year 2023 in DAX.

Power BI

Filtered Sales = CALCULATE(SUM(Sales[Amount]), Sales[Year] [1] 2023)

Drag options to blanks, or click blank then click option'

A=

B>

C<

D==

Attempts:

3 left

💡 Hint

Common Mistakes

Using '==' which is not valid in DAX.

Using greater or less than operators instead of equals.

To filter for the year 2023, use the equals sign '=' for the condition.

5fill in blank

hard

Fill all three blanks to create a measure that calculates average sales per customer in DAX.

Power BI

Avg Sales per Customer = DIVIDE(SUM([1][SalesAmount]), DISTINCTCOUNT([2][[3]]))

Drag options to blanks, or click blank then click option'

ASales

BCustomers

CCustomerID

DOrders

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing table names for sales and customers.

Using wrong column names for customer ID.

The measure sums sales from the Sales table, counts distinct CustomerID from Customers table, then divides.