Tag: powerpivot

12 Excel 2010 PowerPivot: How do I show items with no data? 2013-09-27T12:46:14.490

4 Auto formatting new pivot rows to data bars 2014-05-29T23:23:47.947

3 calculated column in pivot table from power pivot 2014-06-24T21:26:04.677

2 How should I share workbooks that use PowerPivot? 2013-03-21T19:05:52.650

2 With PowerPivots, find items that appear *only* in one category 2014-07-24T03:50:56.827

2 How can I publish excel workbook with data populated using PowerQuery to SharePoint or website and have the data refresh on the site? 2014-09-23T17:51:07.783

2 Changing the Workbook Connection String in PowerPivot 2016-01-04T16:53:04.177

2 Excel PowerPivot Relationships 2018-03-13T08:28:04.657

1 How can you improve an Excel workbook that leverages PowerPivot 2011-10-03T23:15:31.670

1 Excel PivotTable % of a specific value 2011-10-21T20:57:29.213

1 PowerPivot - Your beta software has expired 2011-12-16T15:10:51.817

1 PowerPivot data feed error "Semicolon expected" during import 2013-01-23T17:30:40.787

1 How to display non-hierarchical attributes on same row using Excel Powerpivot? 2013-05-05T01:32:13.343

1 Powerpivot will not install 2013-09-30T16:18:17.000

1 Data Source Credentials issue with Excel PowerPivot 2014-01-07T09:24:52.890

1 Import from Folder data source missing from PowerPivot 2014-05-08T13:01:19.987

1 Listing/grouping variables in PowerPivot table field list 2014-05-21T13:48:22.680

1 Excel 2010 PowerPivot: How do I avoid apostrophes being displayed as ’? 2014-10-28T13:42:20.007

1 Powerpivot: how do I avoid measures from computing until I'm done entering multiple measures? 2014-11-20T05:49:37.007

1 Powerpivot install fails 2015-05-05T11:55:21.430

1 Excel 2013 Workbook Size Optimizer not working 2015-05-28T18:40:25.287

1 How to create a 100% stacked column chart if I have total 2015-09-04T15:49:46.807

1 Calculate % of filtered values from all values in Excel Pivot Table 2015-12-06T23:32:21.660

1 I do not know how to install Npgsql version 3.0.3 2015-12-12T13:22:42.353

1 'Count Distinct' and Min(date) in the same pivot table? 2015-12-16T06:32:51.620

1 How to overwrite measures at a line level in PowerPivot 2016-03-31T19:17:23.390

1 How to use PowerPivot in Excel 2013 (Home and Business) 2016-12-12T15:04:12.107

1 DAX RANKX formula to skip ties properly 2017-02-18T21:00:35.837

1 In Excel, is it possible to create a graph for every category of data, from the same table? 2017-03-22T18:25:50.363

1 Cannot group field in Excel PivotTable 2017-10-30T22:20:56.667

1 Doing calculation in PowerPivot (Excel 2010) based on two tables 2018-02-25T18:32:19.647

1 How to do a distinct select with CountRows in excel? 2018-04-13T14:55:09.503

1 Is there a solution to the constant unhandled exceptions that Powerpivot throws in Excel 2013? 2018-04-19T13:05:48.650

1 Calculating differences between two sheets (efficiency issue) 2018-06-19T04:17:47.970

1 Combine none-unified data in excel based on row-id? 2018-09-12T12:11:22.437

1 PowerPivot - How do I establish a relationship between a table's columns to another table? 2018-12-20T17:59:23.443

1 Replace Static Table Data w/ External Source and Update Pivot Automatically (Excel) 2019-08-16T23:50:46.737

0 How to convert and Excel formula to a PowerPivot formula? 2012-11-22T11:04:44.610

0 PowerPivot for Excel 2010 not installing on Office 2010 Home And Business 2013-03-21T20:47:34.817

0 How to group count by week date in PowerPivot 2013-04-03T20:25:50.050

0 Calculating Annualized Turnover in a Pivot Table or PowerPivot 2013-12-19T19:37:49.227

0 PowerPivot Bar is grayed out 2013-12-19T19:49:14.410

0 Getting #NUM! for outer nests of IF statement division 2014-03-13T16:22:57.300

0 Does MSOLAP.5 automatically ship when the Power Pivot addin is installed 2014-04-11T10:16:46.733

0 Excel 2013 PowerPivot add-in crashes Windows 7 2014-05-16T21:20:55.380

0 In Excel PivotTables, how do I show items that occur in one category but not another? 2014-07-22T01:45:16.393

0 Powerpivot; Get a datadump from SQL vs creating a data model in excel 2014-10-29T12:46:19.273

0 How can I make a time by date chart in powerview 2014-12-01T21:28:31.560

0 Microsoft Powerpivot button not working 2014-12-30T06:37:43.070

0 Setup powerpivot on a server? 2015-04-01T07:03:54.660

0 Calculate total number of open item at each month in Powerpivot 2015-04-14T20:51:35.783

0 Create a box and whisker plot in Excel 2016 2015-06-08T10:19:12.880

0 Two-way data update with Excel PowerPivot tables (Office 2013) 2015-07-20T19:16:52.137

0 Change pivot table layout into "more columns" 2015-07-29T05:30:22.383

0 How do you group by week in Excel PowerPivot? 2015-09-16T15:59:43.080

0 Power Pivot for Excel - version 11 not Installing on Office Professional Plus 2010 2015-09-22T16:03:09.320

0 Variables from Multiple columns lookup to insert new column in Power Query or Power Pivot 2015-10-29T13:06:38.090

0 Is there a way to hide the Field List in an Excel PowerPivot table so that no users can see it? 2015-12-03T19:58:12.710

0 Loading data to power pivot via power query vs. directly to power pivot 2015-12-15T02:36:55.390

0 Excel function/Date Table - Defining week and period 2016-01-07T18:00:26.450

0 Excel Conditional Formatting disappears unless smaller dataset in filter 2016-01-14T15:47:12.337

0 defining a measure of unique value counts 2016-01-22T02:53:43.877

0 POWER PIVOT formula to show previous day based on weekday 2016-02-16T09:01:16.163

0 Names of the PowerPivot tables do not update in PivotTable 2016-02-21T00:50:46.457

0 Combine data from two seperate tables in Power Pivot without using a join based on concatenated key 2016-03-01T20:58:18.633

0 Powerpivot - Flag whether row value in one column exists in another 2016-03-29T17:43:52.903

0 why powerpivot completly brokes if there is no values? 2016-04-04T23:30:48.970

0 In a PivotChart filter, how do I select a just range in the column to display? 2016-05-26T19:11:45.943

0 Total open Qty for an Item 2016-11-17T16:56:31.633

0 Power Pivot Sort By Column Not Working in Excel 2016 2016-12-15T14:05:03.930

0 Power Pivot - Count cells that contain specific text? 2017-01-09T16:54:17.440

0 Power Pivot - Calculating a Defect Rate 2017-01-12T13:02:47.670

0 Excel Pivot Table converting numbers to text in row labels 2017-02-22T20:17:54.460

0 Cannot Install Power Pivot in Excel 2013 2017-03-24T04:36:40.387

0 Why's power pivot measure area grayed out? 2017-09-08T04:44:29.443

0 Vertical and Horizontal Slicer Boxes 2018-08-14T00:01:51.887

0 How to use Power Query to create pivot tables with non-numerical values 2018-09-13T18:45:50.857

0 PowerPivot returning all values 2018-10-30T17:40:59.570

0 Difference between two averages in excel power pivot 2018-11-18T18:33:12.337

0 Excel: Add 3rd "values" column to show percentage of one column against another 2018-12-17T13:13:07.730

0 Excel Pivot - Group by year and week 2018-12-21T12:49:32.797

0 Using a slicer to choose one column of a power Pivot table to exibit 2019-02-01T11:39:39.307

0 Excel 365 - Pivot tables ungroup dates when refreshed; not an issue in Excel 2016 2019-04-10T15:07:16.090

0 Struggling to import Oracle tables via Excel Power Pivot 2019-04-20T16:39:30.953

0 Data Slicers not working properly with Excel 2016 2019-05-08T09:41:58.217

0 Using a Column as a Lookup Range in Power Pivot 2019-05-17T15:11:09.013

0 Change PowerPivot source from External excel to internal table in document 2019-06-11T18:31:42.623

0 PowerPivot get the last value recorded for a date 2019-06-17T21:26:54.653

0 Not able to install power pivot add in in excel 2010 2019-07-11T14:30:20.567

0 Excel PowerPivot - Working out percentages for columns in a PowerPivot 2019-07-18T14:57:06.767

0 How to make a DAX measure NOT to re-calculate on aggregated levels? 2019-08-20T19:57:04.150

0 MS Excel. Slicer alternative when dealing with hundreds of values 2019-09-09T11:44:21.983

0 MS Excel. How to analyse dates when they are heading names? 2019-09-10T08:42:33.530

0 Excel Power Pivot Data model Sum of Max date groupings 2019-09-12T05:34:11.080

0 Power Pivot Measures 2019-10-23T12:07:38.403

0 Find the last balance quantity per customer per month (Power Pivot) 2019-11-05T00:09:30.420

0 Change Excel Slicer from "OR" to "AND" 2019-11-19T21:40:18.180

0 How to Add custom Categories to Transaction Descriptions in an Excel Data Model 2020-01-20T20:19:52.320

0 Excel : list of installed base 2020-02-03T13:57:15.140