Task1: How can a date dim table be created using calendar
auto?
Task 2: What is the process to extract Year, Quarter, Month, Day, and
Month name from the created date dim table using the specified
functions?
Year (use year function)
Quarter (Use quarter function)
Month (use Month function)
Day (use Day function)
Month name ( use Format function)
a. Year (use year function)
b. Quarter (Use quarter function)
c. Month (use Month function)
d. Day (use Day function)
e. Month name ( use Format function)
Replace [CET] with your columnname.
Task 3: How can the Upper, Lower, and Trim functions be applied to a
chosen column in the table?
1.Upper (Use Upper function)
2.Lower (use Lower function)
3.Trim(use Trim function)
f. Upper (Use Upper function)
Converts the whole column in upper case
g. Lower (use Lower function)
Converts the whole column in lower case
h. Trim(use Trim function)
Removes the space between the words. Single space is ignored. Multiple
spaces are removed
Task 4: What are the steps to create new columns by applying
formulas/conditional statements such as If condition, Int(), and
round()?
i. If condition ( conditional columns)
table view
You can do this in table view or in transform query as well.
Power Query
j. Int(), round ()
This will convert any numerical form of number to integer.
The ROUND function is used to round a number to a specified number of digits.
Task 5:How can the Min and Max functions be applied to the new
custom columns?
Min (Use Min function)
Max ( Use Max function)
k. Min (Use Min function)
It retrieves the smallest numerical value from the specified column.
l. Max ( Use Max function)
It retrieves the highest numerical value from the specified column.
Task6: Can you explain the all except function and provide an
example of writing a DAX using the all except function?
The ALLExcept function is used to remove filters from all columns in a table except for the
specified columns. This function is particularly useful when you want to retain filters on certain
columns while removing filters on others.
