OSOllie seongyong Kiminolliekim.hashnode.dev·Feb 4, 2024 · 2 min readExercise: Adding a measureInstructions 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...00
OSOllie seongyong Kiminolliekim.hashnode.dev·Feb 3, 2024 · 6 min readStatistical functions cheatsheetThe 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...00
OSOllie seongyong Kiminolliekim.hashnode.dev·Jan 29, 2024 · 3 min readAdding a calculated table and columnInstructions 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...00
OSOllie seongyong Kiminolliekim.hashnode.dev·Jan 29, 2024 · 3 min readCloning and calculating tablesCloned 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...00
OSOllie seongyong Kiminolliekim.hashnode.dev·Jan 29, 2024 · 6 min readDAX cheatsheetDAX 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...00
