Power Pivot

• 'DATEADD' and Contiguous date selections
• ‘DATEADD’ only works with contiguous date selections.
• "Change Data Source" feature disabled for Pivot Table on PowerPivot in Excel 2013
• "PowerPivot is unable to load the Data Model" in Excel 2016 and Windows 10
• A single calue for column cannot be determined
• All PowerPivot options are greyed out
• All rows show the same data value even if relationships are set.
• An argument of function ‘DATE’ has the wrong data type or the result is too large or too small
• An item with the same key has already been added.
• Calculating monthly backlog in DAX
• Calculating order intake via orderbook and revenue
• Calculating YoY Growth Using powerpivot
• Cannot refresh table - test connection works fine but refresh gives "We couldn’t refresh the connection. Please go to existing connections and verify they connect to the file or server." error.
• Changing the query and data source behind one PowerPivot table
• Circular Dependency Error
• Combine COUNTROWS(DISTINCT( with FILTER(
• comparing current row with previous row
• Copy all measures from one file to another
• Copy from PowerPivot to Different Workbook
• Count clients that make 80% total Sales
• Count zero DAX Formula in Tabular Model
• Create a PowerPivot table based on an existing pivot table
• Create a STEP CHART using PowerPivot
• Create measure that returns text from a column
• CSV won't import to PowerPivot
• Data model error (pfthreadpool.cpp)
• DATESBETWEEN - An invalid numeric representation of a date value was encountered
• DAX - Calculate based on current row value
• DAX - GetValue from columnB when ColumnA is the maximum
• DAX - Return zero if blank
• DAX CALCULATE and ignore slicer selections?
• DAX Calculated Measure for Sum of Max values
• DAX Current member equivalent
• DAX Dimension Composite Key Syntax Question
• DAX equivalent - Count(non number) Partition By
• DAX error: End of input reached
• DAX FIRSTDATE in a filter context - Contoso example
• DAX foreach over values - newbie
• DAX Formula to mark duplicates with a sequential number (1,2,3, etc.)
• DAX IF Time is greater than a value
• DAX Measure filtering on a column in a RELATED table
• DAX SWITCH() error "'SWITCH' does not support comparing values of type Integer with values of type True/False"
• DAX: Create and auto fill a column with numerical sequence
• DAX: Distinct count across 2 tables/columns?
• DAX: Filter multiple values with COUNTAX
• DAX: Find MAX number for unique values
• Delete Rows in Power Pivot Data model
• Display number value without aggregation
• Display top 10 products in power bi desktop report
• Distinct Count of Values Based on Two Columns
• Error: The function____only accepts a column reference as an argument
• ERROR: The relationship cannot be created because both columns selected contain duplicate values.
• Excel PivotTable with boolean filter - Force true AND false to be displayed
• EXCEL POWERPIVOT - CREATE RELATIONSHIP BETWEEN 2 EXCEL TABLES FILES LOCATED IN MY DESKTOP
• Exporting directly from PowerPivot to CSV to TXT
• Filtering Issue "Can't display the data because Power BI can't determine the relationship between two or more field"
• Format data from SQL Server view as date in Excel
• FORMAT(value,"MMM") returning incorrect Month
• Get Matching Item from Unrelated Table - Need Help
• Get the name of a month - PowerPivot v2
• how can i get total sales per customer individually using DAX
• How can I troubleshoot "XML parsing failed" error
• How do I keep slicers and column sizes in my pivot from changing
• How do I populate a slicer dynamically from a selected record within a linked table in a different Excel work sheet
• How Do I Use DAX Variables in Excel 2016 Power Pivot, VAR RETURN?
• How to add a column of source data to an established PowerPivot workbook
• How to calculate RowNumber of a row in DAX
• How to change data source for PowerPivot model
• How to Change\Edit Excel Workbook Data connection string ?
• How to collapse all drilldown rows?
• How to create a Scroll bar for a Chart using Pivot Table and without using Pivot Table ?
• How to disable Multi-selection thing in slicer.
• How to flag unique and duplicate records in PowerPivot (DAX)
• How to handle count of data with “valid to/from” dates in DAX
• How to improve slow PowerPivot performance when adding/modifying measures, calculated columns or Relationships?
• How to increment value of a column conditionally with DAX expression
• How to load PowerPivot data to Excel table
• How to reference an excel cell into a Measure's formula - PowerPivot Table - Excel Sheet
• How to remove broken data model in PoverPivot
• How to Use ALL or ALLEXCEPT with RELATED table columns as filters
• HOW TO: Install Powerpivot Add-In to Microsoft Excel 2007 for 32 Bit on Windows XP
• IF DAX statement between two values
• Is there a way to see the sql code in powerpivot after the initial files have been pulled down.
• Keep getting error when trying to use =related function in PowerPivot
• Link Sharepoint Excel File to Powerpivot Data Model
• Linking multiple pivot tables without slicers
• Loading SharePoint list records into Power Query reg,.
• Looking for DAX function to separate date\time
• Lookupvalue from a subset of a table
• LOOKUPVALUE function not working, and it SHOULD be working
• Merging muliple tables in powerpivot
• Monthname in DAX in english?
• Multiple table arguments are not allowed in the all function
• Object was not found in the cube when the string was parsed ERROR in PowerPivot
• Power BI: How to set refresh for an excel file uploaded in PowerBi.com?
• Power BI: reference one column of a filtered table
• Power Pivot : Data Model not getting refreshed when new rows added in the Excel Sheet
• Power Pivot type mismatch
• Power Pivot Window Does not Launch
• Power Query - Create a list of Months
• Power Query Error Expression.Error: We cannot convert the value .. to type Text
• Power Query Regular Expression Capability
• Powerpivot - "some properties cannot be changed because this connection was modified using the powerpivot add-in"
• PowerPivot Calculated Fields Error: EARLIER/EARLIEST refers to an earlier row context which doesn't exist.
• PowerPivot dates turn to text in excel
• PowerPivot Excel 2016 - An issue with the Data Model is preventing Microsoft Excel from opening this workbook. Try restarting Microsoft Excel
• PowerPivot Nulls replaced by Blank
• Powerpivot pivottable - I can't add or drag a "value field" from the pivottable field list into the "values" section.
• PowerPivot PivotTable independent column
• PowerPivot Refresh Problem
• PowerPivot Retain items deleted from the data source section "disabled"
• PowerPivot showing me blank rows
• Prevent a column value from appearing in a slicer
• Prior Month To Date (MTD) calculation with DAX
• Problem with xlnm filtered database in Powerpivot
• Rankx - Partition By in DAX
• Related DAX Function, addressing BLANK values
• Running Total - Slow Performance
• Show blanks instead of zero in a PivotChart
• Slicers Disappear
• sum column only for unique values in other column
• Tabular Model - Set Default Member of a Dimension
• The 'DB2OLEDB' provider is not registered on the local machine.
• The organization or content of the OLAP cube has been changed ...
• The specified sort criteria is invalid
• The SQL statement is not valid. There are no columns detected in the statement.
• Tiny Font in PowerPivot Field List
• Transfer Data from powerpivot into excel without a source for powerpivot
• Trouble with summing absolute net values
• trying to display a pivot table in a matrix form
• Unable to add Timeline in PowerPivot
• Value from the first row in a filtered table?
• vba refresh.all function does not throw error if the data source connection has problem
• where is the AllowedRowsExpression