Click to edit Master title style,Click to edit Master text styles,Second level,Third level,Fourth level,Fifth level,*,*,SQL Server 2008 R2,的自助式商务智能,Self-service Business Intelligence,BAP302,2,3,Please translate the sign,4,5,6,7,8,9,Please translate the headline,10,11,12,13,14,15,16,Please translate the headline,17,18,19,20,Can this be translated and still be fun?If not,you can delete.,21,22,23,24,25,26,27,Excel Functions in Gemini,28,Lookup Functions,LookupValue(ResultColumn,SearchColumn,SearchValue.),Related(Column),RelatedTable(Table),29,Aggregation Functions,SUMX(Table,Expression),AVERAGEX(Table,Expression),COUNTAX(Table,Expression),MINX(Table,Expression),MAXX(Table,Expression),EARLIER(Column),EARLIEST(Column),30,Table Functions,RelatedTable(Table),Filter(Table,Condition),Distinct(Column),Values(Column),All(Table),All(Column),AllExcept(Table,Col1,Col2,.),31,Variants of Calculate(),Scalar functions,Calculate,CalculateAll,CalculateAllRows,Table Functions,CalculateTable,CalculateTableAll,CalculateTableAllRows,Supporting Functions,All,AllExcept,AllNoBlankRow,32,Time Intelligence Functions,FirstDate,LastDate,FirstNonBlank,LastNonBlank,StartofMonth,StartofYear,EndofMonth,EndofQuarter,EndofYear,DateAdd,DatesBetween,DatesInPeriod,ParallelPeriod,PreviousDay,PreviousMonth,PreviousQuarter,PreviousYear,NextDay,NextMonth,NextQuarter,NextYear,DatesMTD,DatesQTD,DatesYTD,SamePeriodLastYear,TotalMTD,TotalQTD,TotalYTD,OpeningBalanceMonth,OpeningBalanceQuarter,OpeningBalanceYear,ClosingBalanceMonth,ClosingBalanceQuarter,ClosingBalanceYear,33,34,Q&A,