Power BI - Columns and Measures - Revision history

Carsen der at 16:42, 5 July 2023

2023-07-05T16:42:53Z

2023-07-05T16:41:51Z

2023-07-05T16:39:48Z

2023-06-29T14:17:59Z

2023-06-27T22:05:17Z

2023-06-27T22:03:05Z

2023-06-27T22:01:30Z

2023-06-27T15:28:27Z

2023-06-27T15:27:55Z

2023-06-27T15:09:09Z

@@ Line 46: / Line 46: @@
 # Volume Won: Again, just the name of the measure.
-# CALCULATE: This function allows the evaluation of an expression with filters applied. In the case, we see two inputs. The SUM input and the FILTER input, seperated by a comma.
+# CALCULATE: This function allows the evaluation of an expression with filters applied. In the case, we see two inputs. The SUM input and the FILTER input, separated by a comma.
 # SUM: This is the expression to be evaluated. Just like the last time SUM was used, we are evaluating the sum of all the rows in the "size (mil)" column of the "sheet1" worksheet.
 # FILTER: The first and only filter applied to the calculate function. The calculate function can take more than one filter but for this example, we just want one. In the FILTER function, we must specify the sheet and the criteria. The sheet is "sheet1" and the criteria is that the row in the column "[won/lost]" is ="won".

@@ Line 46: / Line 46: @@
 # Volume Won: Again, just the name of the measure.
-# CALCULATE: This function allows the evaluation of an expression with filters applied. In the case, we see two inputs. The SUM input and the FILTER input, seperated by a column.
+# CALCULATE: This function allows the evaluation of an expression with filters applied. In the case, we see two inputs. The SUM input and the FILTER input, seperated by a comma.
 # SUM: This is the expression to be evaluated. Just like the last time SUM was used, we are evaluating the sum of all the rows in the "size (mil)" column of the "sheet1" worksheet.
 # FILTER: The first and only filter applied to the calculate function. The calculate function can take more than one filter but for this example, we just want one. In the FILTER function, we must specify the sheet and the criteria. The sheet is "sheet1" and the criteria is that the row in the column "[won/lost]" is ="won".

@@ Line 22: / Line 22: @@
 Date_Column(New) = FORMAT(Sheet1[date],"ddd, mmm dd/yy")
 [[File:Textbox.png|center|thumb|1233x1233px]]
-Let's break down this DAX expression down.
+Let's break this DAX expression down.
 # Date_Column(New): The text before the "=" sign specifies the name of the new column. This can be anything but for simplicity, we named it something easy to identify.

@@ Line 50: / Line 50: @@
 # FILTER: The first and only filter applied to the calculate function. The calculate function can take more than one filter but for this example, we just want one. In the FILTER function, we must specify the sheet and the criteria. The sheet is "sheet1" and the criteria is that the row in the column "[won/lost]" is ="won".
-This expression may seem complicated to those unfamiliar to coding but expressions like this can be really powerful once one becomes familiar with its usage. The new measure we just created can be seen here:
+This expression may seem complicated to those unfamiliar to coding but expressions like this can be really powerful once one becomes familiar with their usage. The new measure we just created can be seen here:
 [[File:Measure Creation Screenshot 2.png|center|thumb|1230x1230px]]
 Please follow the next tutorial to learn about [[Power BI - Visualizations|visualizations]]

← Older revision		Revision as of 22:05, 27 June 2023
Line 53:		Line 53:
	[[File:Measure Creation Screenshot 2.png\|center\|thumb\|1230x1230px]]		[[File:Measure Creation Screenshot 2.png\|center\|thumb\|1230x1230px]]
	Please follow the next tutorial to learn about [[Power BI - Visualizations\|visualizations]]		Please follow the next tutorial to learn about [[Power BI - Visualizations\|visualizations]]
		+
		+	[[Category:Power BI]]
		+	[[Category:Estimating]]

← Older revision	Revision as of 22:03, 27 June 2023
(No difference)

@@ Line 1: / Line 1: @@
 == Overview ==
-Creating a new column or a new measure both fundamentally do the same thing. They are both methods of manipulating data for easier visualization. For most purposes, creating a new column is the easier method, especially for users who are familier with Excel. The reason that a measure may be used, is that the new values created from it are calculated as they are needed, they are not stored. This means that when the column is hundreds of thousands, or even millions of values, a measure will keep the program running smoothly and quickly, whereas a new column may impact performance and size of the file.
+Creating a new column or a new measure both fundamentally do the same thing. They are both methods of manipulating data for easier visualization. For most purposes, creating a new column is the easier method, especially for users who are familier with Excel. The reason that a measure may be used, is that the new values created from it are calculated as they are needed, they are not stored. This means that when the column is hundreds of thousands, or even millions of rows, a measure will keep the program running smoothly and quickly, whereas a new column may impact performance and size of the file.
 == DAX ==

@@ Line 52: / Line 52: @@
 This expression may seem complicated to those unfamiliar to coding but expressions like this can be really powerful once one becomes familiar with its usage. The new measure we just created can be seen here:
 [[File:Measure Creation Screenshot 2.png|center|thumb|1230x1230px]]
-Please follow the next tutorial to learn about visualizations
+Please follow the next tutorial to learn about [[visualizations]]