daily pastebin goal
70%
SHARE
TWEET

Untitled

a guest May 16th, 2018 106 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SchoolLetter = LEFT(SchoolEnrolment[School Name],1)
  2.  
  3. Month Year = FORMAT(InternetSales[Order Date],"MMM yyyy")
  4.  
  5.  
  6.  
  7. Month Year Sort = FORMAT(InternetSales[Order Date],"yyyyMM")
  8.  
  9.  
  10.  
  11. YTD Revenue = TOTALYTD(Sum(Sales[Revenue]),'Date'[Date])
  12.  
  13.  
  14.  
  15. LY YTD Revenue = CALCULATE([YTD Revenue],SAMEPERIODLASTYEAR('Date'[Date]))
  16.  
  17.  
  18.  
  19. YTD Sales Var = [YTD Revenue]-[LY YTD Revenue]
  20.  
  21.  
  22.  
  23. YTD Sales Var % = DIVIDE([YTD Sales Var],[LY YTD Revenue])
  24.  
  25.  
  26.  
  27. SchoolLetter = LEFT(SchoolEnrolments[School Name],1)
  28.  
  29. Attendance Rate = SUM(Attendance[FTE Days Attended])/SUM(Attendance[Possible Attendance Days])
  30.  
  31. StartofYear = "01-01-"&Dates[Year]
  32.  
  33. Manufacturer Group =
  34. IF(Manufacturer[ManufacturerID] = 7,Manufacturer[Manufacturer],
  35.  
  36. IF(Manufacturer[ManufacturerID] = 2,"Main 4",
  37. IF(Manufacturer[ManufacturerID] = 4,"Main 4",
  38. IF(Manufacturer[ManufacturerID] = 8,"Main 4",
  39. IF(Manufacturer[ManufacturerID] = 10,"Main 4","Others")))))
  40.  
  41.  
  42.  
  43. Manufacturer Grouping =
  44. IF(Manufacturer[ManufacturerID] = 7,Manufacturer[Manufacturer],
  45. IF(Manufacturer[ManufacturerID] = 2,Manufacturer[Manufacturer],
  46. IF(Manufacturer[ManufacturerID] = 4,Manufacturer[Manufacturer],
  47. IF(Manufacturer[ManufacturerID] = 8,Manufacturer[Manufacturer],
  48. IF(Manufacturer[ManufacturerID] = 10,Manufacturer[Manufacturer], "Others")))))
  49.  
  50.  
  51.  
  52. YTD Revenue (limited by last date in Data table) = VAR DataMaxDate =
  53.  CALCULATE ( MAX ( Sales[Date] ), ALL ( Sales ) )
  54.  RETURN
  55.  CALCULATE(Sum(Sales[Revenue]),DATESYTD(
  56. INTERSECT (
  57. VALUES ( 'Date'[Date] ),
  58.  DATESBETWEEN ( 'Date'[Date], BLANK (), DataMaxDate ))))
  59.  
  60.  
  61.  
  62. LY YTD Revenue (limited by last date in Data table) =
  63. VAR DataMaxDate =
  64.  CALCULATE ( MAX ( Sales[Date] ), ALL ( Sales ) )
  65.  RETURN
  66.  CALCULATE (
  67.  YTD Revenue],
  68. SAMEPERIODLASTYEAR ( INTERSECT (
  69.  VALUES ( 'Date'[Date] ),
  70.   DATESBETWEEN ( 'Date'[Date], BLANK (), DataMaxDate ))))
  71.  
  72.  
  73.  
  74. Avg Product Revenue = SUM(Sales[Revenue]) / SUM(Sales[Units])
  75.  
  76.  
  77. https://www.foxsports.com/soccer/stats?competition=1&season=20160&category=GOALKEEPING
  78.  
  79. 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])))
  80.  
  81. Location = SchoolDetails[Postal Address Post Code]&", "&SchoolDetails[State]&", AUS"
RAW Paste Data
Top