SchoolLetter = LEFT(SchoolEnrolment[School Name],1)

Month Year = FORMAT(InternetSales[Order Date],"MMM yyyy")



Month Year Sort = FORMAT(InternetSales[Order Date],"yyyyMM")



YTD Revenue = TOTALYTD(Sum(Sales[Revenue]),'Date'[Date])



LY YTD Revenue = CALCULATE([YTD Revenue],SAMEPERIODLASTYEAR('Date'[Date]))



YTD Sales Var = [YTD Revenue]-[LY YTD Revenue]



YTD Sales Var % = DIVIDE([YTD Sales Var],[LY YTD Revenue])



SchoolLetter = LEFT(SchoolEnrolments[School Name],1)

Attendance Rate = SUM(Attendance[FTE Days Attended])/SUM(Attendance[Possible Attendance Days])

StartofYear = "01-01-"&Dates[Year]

Manufacturer Group =
IF(Manufacturer[ManufacturerID] = 7,Manufacturer[Manufacturer],

IF(Manufacturer[ManufacturerID] = 2,"Main 4",
IF(Manufacturer[ManufacturerID] = 4,"Main 4",
IF(Manufacturer[ManufacturerID] = 8,"Main 4",
IF(Manufacturer[ManufacturerID] = 10,"Main 4","Others")))))



Manufacturer Grouping =
IF(Manufacturer[ManufacturerID] = 7,Manufacturer[Manufacturer],
IF(Manufacturer[ManufacturerID] = 2,Manufacturer[Manufacturer],
IF(Manufacturer[ManufacturerID] = 4,Manufacturer[Manufacturer],
IF(Manufacturer[ManufacturerID] = 8,Manufacturer[Manufacturer],
IF(Manufacturer[ManufacturerID] = 10,Manufacturer[Manufacturer], "Others")))))



YTD Revenue (limited by last date in Data table) = VAR DataMaxDate =
 CALCULATE ( MAX ( Sales[Date] ), ALL ( Sales ) )
 RETURN
 CALCULATE(Sum(Sales[Revenue]),DATESYTD(
INTERSECT (
VALUES ( 'Date'[Date] ),
 DATESBETWEEN ( 'Date'[Date], BLANK (), DataMaxDate ))))



LY YTD Revenue (limited by last date in Data table) =
VAR DataMaxDate =
 CALCULATE ( MAX ( Sales[Date] ), ALL ( Sales ) )
 RETURN
 CALCULATE (
 YTD Revenue],
SAMEPERIODLASTYEAR ( INTERSECT (
 VALUES ( 'Date'[Date] ),
  DATESBETWEEN ( 'Date'[Date], BLANK (), DataMaxDate ))))



Avg Product Revenue = SUM(Sales[Revenue]) / SUM(Sales[Units])


https://www.foxsports.com/soccer/stats?competition=1&season=20160&category=GOALKEEPING

Web URL = IF(LEFT(SchoolDetails[Internet Site],3) = "www",CONCATENATE("http://",SchoolDetails[Internet Site]),IF(ISBLANK(SchoolDetails[Internet Site]) = TRUE,"https://schoolsdirectory.eq.edu.au/",CONCATENATE("http://www.",SchoolDetails[Internet Site])))

Location = SchoolDetails[Postal Address Post Code]&", "&SchoolDetails[State]&", AUS"