Scribd
Upload
61 views4 pages

Module3 DAX Assignment

The document outlines a series of assignments involving DAX formulas for data manipulation and analysis. Key tasks include creating new columns for net units, city names, order days, and tax slabs, as well as generating performance metrics from an order table. The final deliverable is a .pbix file containing the completed work based on specified datasets.

Uploaded by

Godwin Sam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
61 views4 pages

Module3 DAX Assignment

The document outlines a series of assignments involving DAX formulas for data manipulation and analysis. Key tasks include creating new columns for net units, city names, order days, and tax slabs, as well as generating performance metrics from an order table. The final deliverable is a .pbix file containing the completed work based on specified datasets.

Uploaded by

Godwin Sam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 4

S.

GODWIN SAM

Module 3
About Assignment

Q1) Using DAX formulas, create a new column ‘Net_Units’ as the difference of ‘Units’ and
‘Cancelled_Units’ in the sale table

Net_Units = [Units] - [Cancelled_Units]

Q2) Using DAX formulas, rename ‘City’ to ‘City_Old’, create new column ‘City’ with only the city
name i.e., removing the country part; from the two files ‘‘Mod3_Raw_CityTier_v0 1 ‘and
‘PinCode-Geo’.

City = LEFT([City_Old], FIND(",", [City_Old]) - 1)


S. GODWIN SAM

Q3) Create a field called ‘OrderDayOfWeek’ which should contain the day of the week, e.g.,
‘Monday’

OrderDayOfWeek = FORMAT([OrderDate], "dddd")

Q4) To be able to look at weekly trends, using DAX formulas, create a field called
‘OrderWeekStart’ which contains the date for the start of the week of the sale. - Note that your
week should be starting from Monday - Format this field to display ‘Nov 06’ for November 6th 5.
Update the relationships to ensure all tables are connected as expected

OrderWeekStart = [Order Date] - WEEKDAY([Order Date], 2) + 1

OrderWeekStartFormatted = FORMAT([OrderWeekStart], "MMM dd")

Q5) Tax Slab Calculation: All the products sold (profit column) from the store are taxed with a
standard tax slab of 2%. Your manager wants you to create a tax slab column so that it can be used
for visualization.
S. GODWIN SAM

TaxSlab = [Profit] * 0.02

Q6) Performance of Query: The manager also wants to check on the performance of the power
query. So, he is asking to generate the metric table as well.

PerformanceMetrics =
SUMMARIZE(
'order table',
'order table'[Order Date],
"Total Orders", COUNT('order table'[Order ID]),
"Total Profit", SUM('order table'[Profit])
)

After completing your task. You have been requested to submit your .pbix file.

DataSet to be used:
S. GODWIN SAM

For questions: 1, 2, 3, 4 follow the 5 files


For questions: 5, 6 use the order table.csv

You might also like