Skip to main content
Stack Overflow
  1. About
  3. For Teams
Filter by
Sorted by
Tagged with
0 votes
0 answers
79 views

I'm fetching data from a SQL Server database through a query in Power Pivot / Excel 365. It's to gather sales data from the rows of all the invoices in a particular time frame so I'm extracting fields ...
0 votes
1 answer
114 views

I'm updating an excel spreadsheet which has VBA codeing in the background. The changes I have made to a table means the vba code now doesn't work correctly. The original code is: Public Sub ...
0 votes
0 answers
40 views

AI is driving me into a dead end. I can't solve the problem. I have data in Power Pivot in the following format: I need to create a report that will track the dynamics of changes in reasons. I want ...
1 vote
1 answer
68 views

I'm connecting to a Power BI semantic model in Excel and using the CUBEVALUE function to retrieve data. Each formula contains around 10–11 member expressions, and everything works as expected when I ...
UII's user avatar
  • 11
0 votes
0 answers
59 views

My excel file has a sheet with 5 "global" slicers that I want to apply to all the pivot tables in the other sheets Each other sheet has its own "local" slicers which are connected ...
0 votes
1 answer
106 views

I want to create power pivot tables using the distinct count function - which is only available when you "Add this data to the Data Model". It seems I need to create a connection to the ...
0 votes
0 answers
41 views

I get the below listed error when I try to change the data type for 2 columns in my Power Pivot I have tried to refresh the sata, resave it in the original file, and then refresh the data in the power ...
0 votes
0 answers
26 views

I have to create a interactive table dashboard showing Last 1 Week, Last 4 Week, Last 13 Week, Last 26 Week and Last 52 Week columns for a list of sales products. I need to show 6 different measures ...
0 votes
1 answer
83 views

I have 2 tables in power query which I would like to append. But before appending these 2 tables I would like to implement the following subtraction in power query. How to get around with this ? many ...
0 votes
1 answer
55 views

Edit. I would like to have average unique visits e.g. average all Mondays, all Tuesdays all Wednesdays in a given month. If there are 4 Tuesdays, I would like to see an average value of visit on ...
1 vote
1 answer
83 views

I have two tables (i.e. 1st is 'Sales' Table, 2nd is 'Territory' table) in my Power Pivot, and I have established relationships between the two using a 'territory' column. The 'Sales' table contains ...
1 vote
1 answer
27 views

I am working in Excel with power pivot. I have 2 tables: a calendar table and a data table. The calendar table has 3 relationships with the data table. In the data table, there are 3 date fields: Case ...
Txtcher's user avatar
  • 11
0 votes
1 answer
105 views

I have created 3 tables in my worksheet: names, roles, costs names: ID NAME ROLE 1 A 1 2 B 2 roles: ID ROLENAME SALARY 1 X 10 2 Y 50 costs: ID NAMEID WORKEDHOURS 1 1 10 2 2 10 The tables are related ...
0 votes
1 answer
26 views

I have a dataset that has Grocery store name, department name, Employee name... I am trying to Count the number of employees by department to get a total number of employees by department and then ...
0 votes
2 answers
130 views

I am in the middle of an assignment and need to make an easy way to "filter" a bill of material through power pivot. Imagine the below is my dataset (simplified) If I want to have an output ...

15 30 50 per page
1
2 3 4 5
...
125

AltStyle によって変換されたページ (->オリジナル) /