PDA

View Full Version : Power Pivot & DAX


  1. Return parent from cubemember
  2. Extracting Calendar Info From Outlook/Exchange 2010
  3. PowerPivot file crashing on opening
  4. DAX Measure to Return Top 10 Items
  5. Trouble Installing PowerPivot
  6. Conquer Your Calendar: Use PowerPivot To Analyze Your Time
  7. PowerPivot to Analyze Tweets
  8. DAX Measure to calculate Average within a percentile range
  9. Apparently related tables yielding results in pivot table as if unrelated
  10. How to calculate values between two different tables
  11. DAX measure to count values above average
  12. Excel Web App with Stock quotes
  13. Powerpivot on SharePoint Online - how to handle external data refresh
  14. Multiple Member Expressions in CubeValue Formula
  15. How to start PowerPivot
  16. Need DAX formula for PowerPivot
  17. Is it possible to connecting PowerPivot data from another Excel file?
  18. Dax formula for cumulative - can't get it to show cumulatives in no change months
  19. Pivot table data in column format
  20. Sort by column
  21. Question concerning text software
  22. Can't get PowerPivot installed
  23. Excel Formula to PowerPivot DAX
  24. Summing a column in the same table for each row
  25. Powerpivot relationship puzzle
  26. using concatenate in a cubeset formula as well as a top count
  27. Sharing Excel PowerPivot & Power Query Documents
  28. Auto Generated Table from PowerPivot
  29. DAX measure to create an index
  30. PowerPivot Date not as Date in calc?
  31. PowerPivot - DRILLTHROUGH doesn't seem to help me, data does not pops out =/
  32. How do I do this
  33. Hide columns from client tools does not hide them
  34. Powepivot Calculation
  35. PowerPivot Relationship Trouble
  36. Calculated Column using Calculate with Filters over set of rows
  37. Adding two columns with unique data with DAX
  38. Drill down doesn't honor FILTER
  39. Excel 2010 OLAP Cube Extensions
  40. Relation error message in pivot table when established relation in powerpivot - help!
  41. DAX Measure: Count number of cities in each state
  42. Connecting two timeslicers to one command
  43. GetPivotData - floating reference - on PowerPivot
  44. Pulling Data from Sharepoint via Power Query - Data Format Error
  45. PowerPivot x-axis date values
  46. Dynamic DAX measure for value field settings
  47. Dax formula to sum actual and forecast columns
  48. PowerPivot return value of last date for each Unique value
  49. User View on Power Pivot
  50. Grouping a Column in DAX
  51. PivotTable
  52. Sum and Average in the same measure
  53. Cascading values
  54. How to sum an IF-AND function in powerpivot...
  55. Which Data Import Method to Use in this Scenario ?
  56. Setting a Maximum value for a DAX measure
  57. Data Model as a Data Source
  58. How to Insert new PowerPivotChart into Excel 2013 via VBA?
  59. Excel 2010 ... Connection Changed from "PowerPivot Data" to "ThisWorkbookDataModel"
  60. Changing power pivot table appearance
  61. True Many to Many - Product manufacturers and categories
  62. Counting values in previous period(s) DAX
  63. Want to be able to delineate a table based upon a slicer
  64. Add columns into source but will not come through into Power Pivot
  65. PowerPivot and PowerView for MAC
  66. Selecting Drill Down Columns
  67. Complicated CALCULATE DAX Expression Help
  68. Dax Expression with Variable v Hardcoded
  69. Error in Power Pivot after install Power Query
  70. Excel Cube / web interface
  71. Calendar table but with times of the day
  72. Show variables without data
  73. Only show top N items for given filter selection
  74. TOPN function
  75. Rankx challenge
  76. Running total (no dates)
  77. Power Pivot - filter with calculated measure
  78. DAX - Parent Category Total
  79. Calculate() with filter() not respecting the current filter context - - need Help plz
  80. How to count the number of customers without deposit accounts
  81. GETPIVOTDATA formula with multiple criteria
  82. Return Result from Many to Many relationship
  83. Import data in powerpivot from another table in powerpivot
  84. Making the PowerPivot Tab appear
  85. CALCULATE with multiple filter conditions against a date - replicate SUMIFS
  86. Export CSV for large data cubes
  87. Intersect - except - calculatetable
  88. Student T-distribution in DAX
  89. DAX Formula for Identifying Mismatches
  90. The Power Pivot Strategy?
  91. Dashboard shows every employee in history of company. 2 columns start and end date
  92. 1st OLAP Cube! Excel Expert Training
  93. DAX formula to distribute Revenue over months
  94. Opening power pivot workbook in earlier version of excel
  95. Help with the Addcolumns DAX function to create a date calendar
  96. Vba power pivot slicer
  97. Power Pivot Refresh Time
  98. Calculated Columns - Total Amortized and Total Unamortized
  99. Refreshing Queries using VBA - Message Alert for Queries that Failed to Refresh
  100. Drilldown 1000 row limit in PowerPivot or PowerBI.com Analyse in Excel
  101. What's the best calendar strategy?
  102. Split data from data model into separate sheets based on a clolumn value
  103. Power Pivot Drill Down capability on "Act Vs Bgt" Measure
  104. YTD column
  105. How to compare two worksheets in a dynamic way
  106. Strange DAX Error
  107. Group then show items only <> $0
  108. PowerPivot drill down capabilities
  109. Distinct Count Issue
  110. Measure to combine two fact sheets
  111. Cubevalue function referring cubemember cells and plain memeber name in a cell
  112. In a measure, how do I change a row context into a filter context for a text column?
  113. Income Statement - Year and Month Slicers
  114. In Correct Drill Down Value PowerPivot Table
  115. Cumulative Total Based on Inactive Relationship Dates using USERELATIONSHIP