PDA

View Full Version : PowerPivot Questions

  1. X functions in DAX?
  2. Previous Month Variance Column
  3. What is PowerPivot and Why Do I Care?
  4. Chart based on cube function
  5. Percentage of Sales
  6. Refecence Column Total in Measure
  7. Filtering a column based on the values in a different column in the current context
  8. Proper way to set up a PowerPivot for the web
  9. The Field You Are Moving Cannot Be Placed in that PivotTable area
  10. Charts
  11. aggregating data in two different PowerPivot tables in one Pivot Table
  12. Client Workbook Model
  13. Use of powerpivot for comparing unknown related periods
  14. Union in Powerpivot
  15. Value Filter in PT using 2010 vrsion
  16. Slicers: delete/disable slicer member?
  17. Slicer to display data from (defined) subsequent rows???
  18. Modifying a Powerpivot Query
  19. Incremental Load ???
  20. Calculate the difference between 2 dates (Lag Time)
  21. Recommended RAM for PowerPivot
  22. 2 Different Power Pivots?
  23. Need help setting up correct steps for daily refresh
  24. How to find rate based on client, date and rate history
  25. Summing Values for Unique Records
  26. PowerPivot add-in problem
  27. Powerpivot tab missing - usual stuff doesn't help.
  28. Creating P&L type reports with PowerPivot?
  29. Attempting to calculate product of previous values
  30. Updating PowerPivot using VBA
  31. Thoughts on source abstraction and common functions
  32. Basket Analysis in Powerpivot /Dax
  33. Trying to combine multiple large excel sheets into one power pivot table
  34. Unwanted Sounds occuring when switching workbooks
  35. Filter PowerPivot/MDX Query
  36. Do all of my users need the PowerPivot add-in to use my pivot tables?
  37. Powerpivot Lookup
  38. Combine 80 sheets in one workbook
  39. Dax Measure Help - Calculate with Max/min for dates
  40. powerpivot help!
  41. Order of Measures in PowerPivot Field List
  42. Memory Pressure Issues with PowerPivot
  43. Sort Pivot Results Ascending
  44. PowerPivot Table freezes up after changing measure attribute from Currency to decimal
  45. DAX Formula for Avg/Max Measure
  46. Merge tables
  47. Looking for simple DAX formula to spearete date\time
  48. Power Pivot and salesforce
  49. Switch To option disabled
  50. Excel OLAP question referencing other cells
  51. Essbase and Powerpivot
  52. Dax Formula Problem
  53. Parametrized request in PowerPivot
  54. Multiply by line
  55. "Not enough storage is available to process this command"
  56. How can I create Variance using New Measure
  57. How to show text into a pivot table
  58. How to identify differently spelled suppliernames
  59. Pivot table query
  60. How to drill down in Pivots
  61. problems upgrading to version 11.0.2100.60 of powerpivot
  62. Things you would love to see in PPv3.0
  63. Can I filter a Field in a slicer?
  64. trying to get an average value
  65. DATEADD function omitting values
  66. Power Pivot to Excel workbook: shows more tables then sheets? Xhm etc?
  67. Power Pivot Importing blank lines?
  68. In theory could this work? Mapping master rep list to different reports/power pivot?
  69. Using Oracle XE as a Data Source
  70. Calculated Column and refering to row values.
  71. Measure to Calculate Net Subscribers per Month
  72. Filter Results using a Measure result
  73. Pivot by 2 fields in Date table and reflect 2 different relationships for rows and columns
  74. Grand total average for sum sales per month
  75. Sum of- in Pivot
  76. Pivot Table Solution
  77. Problem with Calculated field not doing expected
  78. Lookups from lots of small tables
  79. How to split postal area from post code
  80. FIND has wrong data type error
  81. Error adding a column to powerpivot
  82. Speeding up Powerpivot
  83. Do recepients of a PowerPivot Report need to have Excel 2010 and PowerPivot installed to view
  84. "The field you are moving cannot be placed" error: pivot table was working
  85. Thinks all my dates are text for sorting
  86. Dynamic Weighted Averages
  87. Error on Import saying max amount exceeded ?
  88. Non-Contiguous Date Ranges
  89. I can't format dates
  90. Sum Distinct?
  91. Power Pivot Charts sort
  92. sort of lookup/measure question!!!
  93. Recipients of power pivots: can you block out the power window?
  94. ERROR - CALCULATION ABORTED: MdxScript(Sandbox) (7, 47) The value for column 'EmailsDelivered' in table 'Table1' cannot be determined in the current context.
  95. To measure the cycle time between similar transactions
  96. Table Import Wizzard
  97. Transposing values to be rows
  98. DaX Month and Year
  99. GETPIVOTDATA #REF for Date
  100. one pivot table from two sources?
  101. powerpivot question
  102. Get MIN date across related tables?
  103. Sumx? Calculate?
  104. stacking Prev period underneath
  105. PowerPivot
  106. concatenate rows in column
  107. Pull text from related table
  108. Error message
  109. POWERPIVOT Crashes
  110. Division of totals/subtotals
  111. PowerPivot in Windows 7 XP Mode
  112. Frequency distribution in PowerPivot
  113. Filter negative numbers from pivot using macro
  114. How do I create Measure to filter sum of value
  115. Failing to understand concepts behind Time Intelligent functions
  116. combining two tables in pivot table
  117. So can I reverse a key table to one-to-many?
  118. Fiscal Calculations: Need Qtr, Month and Year...show at once
  119. Get last change in price history table
  120. Hide subtotals in pivottable with only one row
  121. PivotTable autofit column width question
  122. Actual vs Budget: multiple measurements, periods
  123. Cubeset function returns #N/A
  124. Curr Month cume / Prev Months Total