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