You can use the calculate function to measures. Bike Return Rate = CALCULATE( [Return Rate], ‘Product Categories Lookup'[CategoryName]=”Bikes” ) Bike Returns = CALCULATE( [Total Returns], ‘Product Categories Lookup'[CategoryName] =”Bikes” ) Bike Sales = CALCULATE( [Quantity Sold], ‘Product Categories Lookup'[CategoryName] =”Bikes” ) Original Mesures … [Read more…]
Allows you to pull data from another as long it has a relationship e.g. ONE to MANY. You will be pulling from the “many side.” The following pulled the retail price from the Product Lookup table to the sales data table. Retail Price = RELATED(‘Product Lookup'[ProductPrice] ) After the data was collected in the new … [Read more…]
Add Column Day of Week = WEEKDAY( ‘Calendar Lookup'[Date], 2 //This is the start of the week ) The column is populated with the number day of the week The following is based on the column above created to get labe the date as a weekday or weekend. Weekend = … [Read more…]
SKU Category = LEFT(‘Product Lookup'[ProductSKU], SEARCH( “-“, ‘Product Lookup'[ProductSKU] ) -1 )
Month Short = UPPER( LEFT(‘Calendar Lookup'[Month Name], 3 ) )
Month Short = LEFT(‘Calendar Lookup'[Month Name], 3 )
Customer Full Name (CC) = ‘Customer Lookup'[Prefix] & ” ” & ‘Customer Lookup'[FirstName] &” “&’Customer Lookup'[LastName]
Education Category = SWITCH( ‘Customer Lookup'[EducationLevel], “High School”,”High School”, “Partial High School”,”High School”, “Bachelors”, “Undergrad”, “Partial College”, “Undergrad”, “Graduate Degree”,”Graduate”)
Customer Priority = IF( ‘Customer Lookup'[AnnualIncome]>100000 && ‘Customer Lookup'[Parent]=”Yes”, “Priority”, “Standard” )
Income Level = If( ‘Customer Lookup'[AnnualIncome]>=150000,”Very High”, If( ‘Customer Lookup'[AnnualIncome]>=100000,”High”, If( ‘Customer Lookup'[AnnualIncome]>=50000,”Average”, “Low”)))
Creates a new column and Checks the value by using TRUE and retuning a Text Value Price Point = SWITCH( TRUE(), ‘Product Lookup'[ProductPrice] > 500,”High”, ‘Product Lookup'[ProductPrice] > 100,”Mid-Range”, “Low” )
If statement Adds a column Parent = IF( ‘Customer Lookup'[TotalChildren] >0, “Yes”, “No” )
The code below as a adds a column and works like an IF with multiple variations. Note can’t use numbers and text Month Number (DAX) = SWITCH( ‘Calendar Lookup'[Month Name], “Janauray”,”1″, “February”,”2″, “March”,”3″, “April”,”4″, “May”,”5″, “June”,”6″, “July”,”7″, … [Read more…]