Excel 2013 PowerPivot, :
PowerPivot . , , , .
PowerPivot , .
PowerPivot.
DAX , , . DAX Data Analysis Expressions ( ). DAX 117 , . 81 Excel , PowerPoint. 54 . .
, , .
.
.
, , , URL -.
.
PowerPivot Server, PowerPivot SharePoint.
, 64- Office PowerPivot. , , , PowerPivot 10 , PowerPivot. 64- Office 2013 , 4 , 32- Windows.
PowerPivot. Office 365, Office 2013 Pro Plus, Office 2013 Enterprise Excel 2013, PowerPivot. , :
1. Excel 2013. PowerPivot (. 8)? , .
2. g , . , , COM (. 9).
3. Microsoft Office PowerPivot for Excel 2013. (. 9). (, PowerPivot for Excel 2013. "PowerPivot for Excel" Excel 2010, Excel 2013 .)
|
|
4. PowerPivot, Excel 2013 .
Excel 2013 PowerPivot (. 8).
. 8. PowerPivot
. 9. PowerPivot
. 1,8 . , BigDatal.txt ( . 10). . , , PowerPivot. , , .
. 10. , 1,8 . , Excel
, 1,8 . , PowerPivot .
1. PowerPivot. . PowerPivot, (. 11). , PowerPivot. PowerPivot : , .
. 11. , PowerPivot Excel, PowerPivot,
2. BigDatal.txt. . .
3. . .
4. .
5. . , PowerPivot .
6. , . , , , .
7. - , . . , , , . , (. 12).
. 12.
8. : . , (, ). , .
9. PowerPivot . , (. 13).
. 13. PowerPivot 1 550 000
10. . , PowerPivot.
|
|
11. PowerPivot 1,8 . . . , (. 14).
. 14. , Excel
. . , , PowerPivot. 14.03.2001. . , , .
, , , . Excel.
PowerPivot Excel, Excel. . 1 , , . , .
, ( Excel).
, 1,8 . , , . , 1,8 . , , Excel. .xlsx , . 58 , Excel 4 .
Excel . PowerPivot []. . Excel, . PowerPivot. , , (. ), .
, :
1. , , (. 15).
2. Ctrl+Shift*.
3. , Ctrl+C.
4. PowerPivot Excel.
5. , PowerPivot. , 1,8 . .
6. PowerPivot . .
7. , , , (. 16). .
. 15.
. 16.
PowerPivot , . : PowerPivot (. 17). , , Excel. Excel , PowerPivot .
. 17. PowerPivot
Excel . . . Excel, PowerPivot. , PowerPivot . , Excel PowerPivot:
|
|
1. , ( . 15) , Ctrl+T.
2. . 1. , , _.
3. PowerPivot . , PowerPivot (. 18).
. 18. PowerPivot _
. Excel . PowerPivot :
1. PowerPivot . , (. 19).
. 19.
2. (BigData) , , . , .
3. PowerPivot, , PowerPivot.
DAX. , PowerPivot, , . DAX PowerPivot.
1. PowerPivot. , PowerPivot.
2. . .
3. fx, . , . . : Excel.
4. YEAR OK (. 20). . PowerPivot =YEAR([ ]. Enter. Excel , .
5. . , , (. 21).
. 20. YEAR
. 21. YEAR
:
1. PowerPivot. , (. 22).
2. , . Excel. , PowerPivot. , , ( ).
3. PowerPivot BigData . . Excel , (. 23). , , 1,8 . .
|
|
. 22. PowerPivot
. 23. 1,8 . ,
. , , ..
PowerPivot Excel. Excel, PowerPivot . PowerPivot, , PowerPivot OLAP . PowerPivot , :
(, , ..). g g . , , , , , , , .
( ). , , , , . Enter . , PowerPivot.
Excel . , PowerPivot , PowerPivot .
, , Excel . , Excel 2013. 1,8 . .
DAX
DAX (YEAR) , PowerPivot. 81 , Excel. DAX Excel , . DAX . , , ( ). DAX 54 . PowerPivot .
DAX . Excel, . DAX Excel:
Excel YEARFRAC, . , Excel. . Excel . . Excel. Excel . Excel Lotus 1-2-3. . .
Excel FORMAT.
CALCULATE.
RELATED.
DAX BLANK(). ALLN0NBLANKR0W FIRSTNONBLANK, BLANK() IF() .
SWITCH. 1 255, SWITCH .
RELATED, . PowerPivot , PowerPivot. Excel . PowerPivot RELATED.
|
|
BigData, [] ( ). , . . , .
, PowerPivot . , . PowerPivot: = []. , . , . RELATED(. . (. 24). . Enter. . , , .
. 24. PowerPivot DAX
, . . 1,8 . PowerPivot. DAX , .
DAX. DAX . , . . 25 , 5:12 . DAX 16 . , , 1,8 . , . - BigData.txt PowerPivot , () . , .
. 25. PowerPivot
DAX. DAX , . , DAX. 6, . 25. , 6. , . , .
. , 6, 2006 . Bellevue Square Managers, . . Eyewear. . , . DAX , DAX.
. Excel, PowerPivot g . . . , , . . f. , .
, . , , . , . . , (. 26). , . PowerPivot , (. 27). , !
. 26.
. 27.
. (. 28) :
=SUMX(BigData;BigData[])/[]
. 28.
, , .
. . . 29 5. , 01.06.2014. ( ) Excel- .xlsx
. 29. 5
, , , DAX. . G6 , 165 , - . , , 165 , ( ) , . ?
, , 5, , . DAX, . , , , . DAX CALCULATE . , .
CALCULATE . , , . = , DAX = , , . DAX, . , . , (. 30):
=CALCULATE([ ];Sls[]="")
.
. 30. DAX
:
(. 30) | =CALCULATE([ ];Sls[]="") |
=CALCULATE([ ];Sls[]<>"") | |
=[ ]/[] | |
=[]*[] | |
=[]+[ ] |
, . 911 2 ( 6, . 31), . . 30 31. , .
. 31.