Distinct Clause
DISTINCT clause is used to remove duplicates from the result set of a SELECT statement.
select payment_method from orders
select distinct(payment_method) from orders
Command Palette
Search for a command to run...
Comments
Join the discussionNo comments yet. Be the first to comment.
More from this blog
Exercise: Adding a measure
Instructions Create a new Power BI project called Exercise – Adding a measure. Follow the steps below to complete the exercise. Step 1: Create a Quick Measure. Once the data is loaded into the data model, create a new quick measure called Running To...
Feb 4, 20242 min read
Statistical functions cheatsheet
The AVERAGE function The AVERAGE function, also known as the mean, sums up all the numbers in a dataset and divides the result by the total count of numbers. This function is frequently used to identify a central tendency in a dataset. It is benefici...
Feb 3, 20246 min read
Adding a calculated table and column
Instructions Step 1: Remove all duplicate values and set the relationships between the tables. Remove all duplicate values from the SalesOrderNumber column of the Sales fact table. Ensure that one-to-many relationships exist between the fact table an...
Jan 29, 20243 min read
Cloning and calculating tables
Cloned tables Cloning a table means duplicating the original table. In other words, creating an exact copy. The cloned table inherits all the original table's columns, data, and relationships. A cloned table is useful if you want to perform manipulat...
Jan 29, 20243 min read
DAX cheatsheet
DAX syntax A DAX formula always starts with an equal operator (\=). After the equals sign, you can provide any expression that evaluates to a scalar or can be converted to a scalar. Let us understand the syntax with an example by breaking down the fo...
Jan 29, 20246 min read