python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
One to many relationship excel
I have a list of part's and their quantities. These parts are used to build sub assemblies and are also used with the sub assemblies to build the final product. These parts are used on multiple produc...
Michael Thomas
Votes: 0
Answers: 0
Pivot table showing too many rows with DAX measure
Consider the following two tables
Major
Major Department
Department Name
Department Number
Produce
Produce
2
Produce
Taxable Produce
3
Frozen
Frozen
5
Grocery
Grocery
1
Grocery
Taxable...

Matthew
Votes: 0
Answers: 1
excel PowerPivot Auto Calculated Measures & Columns
After looking at a few similarish questions I figured I needed something more specific so asking here. I will start by explaining the situation:
The Setup
I have a Store which sells Cakes, Cookies and...
Sargent179
Votes: 0
Answers: 1
Combine multiple .xls files that are formatted as txt files into one pivot?
So I have files that I get from a 3rd party everyday, they have been building up for over a year and I need to combine them into summary pivots, 1 file/pivot for each month.
So I have ~30 files that a...
MagentaLavaLamp
Votes: 0
Answers: 1