Notes: Excel Power Bi Web Development
  • Home
  • Home

Calculate Embed

July 27, 2023 by admin

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…]

Posted in: Uncategorized Tagged: Calculate, Measures

Related Function

July 26, 2023 by admin

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…]

Posted in: Uncategorized Tagged: Related

Date Functions

July 26, 2023 by admin

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…]

Posted in: Uncategorized Tagged: Date Functions, IN Funcation, Year

Using the Left and Search Function to return part of a text field

July 25, 2023 by admin

SKU Category = LEFT(‘Product Lookup'[ProductSKU], SEARCH(     “-“,     ‘Product Lookup'[ProductSKU]     )     -1 )

Posted in: Uncategorized Tagged: Calculated Column, Search Function, Text Functions

Text Function Left Column Addition With Second Function Upper

July 25, 2023 by admin

Month Short = UPPER( LEFT(‘Calendar Lookup'[Month Name], 3 ) )

Posted in: Uncategorized Tagged: Calculated Column, Text Functions

Text Function Left Column Addition

July 25, 2023 by admin

Month Short = LEFT(‘Calendar Lookup'[Month Name], 3 )

Posted in: Uncategorized Tagged: Calculated Column, Text Functions

CONCATENATE Column Data

July 25, 2023 by admin

Customer Full Name (CC) = ‘Customer Lookup'[Prefix] & ” ” & ‘Customer Lookup'[FirstName] &” “&’Customer Lookup'[LastName]

Posted in: Uncategorized Tagged: CONCATENATE, Text Functions

Using Switch to Combine Categories

July 25, 2023 by admin

Education Category = SWITCH( ‘Customer Lookup'[EducationLevel], “High School”,”High School”, “Partial High School”,”High School”, “Bachelors”, “Undergrad”, “Partial College”, “Undergrad”, “Graduate Degree”,”Graduate”)

Posted in: Uncategorized Tagged: Calculated Column, Switch

If for Two Values Using &&

July 25, 2023 by admin

Customer Priority = IF(     ‘Customer Lookup'[AnnualIncome]>100000 &&     ‘Customer Lookup'[Parent]=”Yes”,     “Priority”,     “Standard” )

Posted in: Uncategorized Tagged: Calculated Column, If statement

Multiple Level of Income IF Statement

July 25, 2023 by admin

Income Level = If( ‘Customer Lookup'[AnnualIncome]>=150000,”Very High”, If( ‘Customer Lookup'[AnnualIncome]>=100000,”High”, If( ‘Customer Lookup'[AnnualIncome]>=50000,”Average”, “Low”)))

Posted in: Uncategorized Tagged: Calculated Column, If statement

Switch Using True for Numbers

July 25, 2023 by admin

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” )

Posted in: Uncategorized Tagged: Calculated Column, Switch

If statement  Calculated Column

July 25, 2023 by admin

If statement Adds a column Parent = IF(     ‘Customer Lookup'[TotalChildren]    >0,     “Yes”,     “No” )

Posted in: Uncategorized Tagged: Calculated Column, If statement

SWTICH Dates

July 25, 2023 by admin

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…]

Posted in: Uncategorized Tagged: Switch

About This Site

This may be a good place to introduce yourself and your site or include some credits.

Copyright © 2023 Notes: Excel Power Bi Web Development.

Mobile WordPress Theme by themehall.com