powerpivot 2013

Hello, This is my first post here. I try to learn DAX and can't figure out how to Count the number of Active Contracts by Market. Could anyone give me a hint ? Kind regards, Ola 3 tables (Contracts, Repairs, Dates): 1. Contracts contains ; ContractNo, StartDate, EndDate, Market 2. Repairs...

Thanks for clicking! I've searched the forum for similar issues and came up with nada. A few posts are close and I feel like this problems should be solvable, but I've been banging my head against a wall for three days on this and (surprise!) I'm getting quite frustrated with Powerpivot. I've...

Hi guys, Does anyone know steps I can take to get PowerPivot 2013 for my Office 365 Personal account???

hi there everyone, i am struggling with the following task in PowerPivot/Powerview for excel2013 (see tables below) : Table A: "Jobs Data" has information on "Production Jobs" - each row has a unique job ID number. Table B: "Direct Labor Data" has records with information about "direct labor"...

I have two tables, similar to below: Roster: <tbody> Region Name AMS Jon AMS Nancy AMS Adam </tbody> Sales: <tbody> Region Name Sales Amount Has Sale AMS Jon $100 1 AMS Nancy $200 1 AMS Nancy $50 1 AMS Jon $100 1 AMS Jon $150 1 </tbody> The two tables are connected by the...

Apologies if I am not posting in the correct forum, please feel free to move if it needs to be. We are in the middle of collecting a pretty big set of data that we are about to summarise so we can then analyse, and would appreciate some help in either creating a Macro, or writing a little bit...

Over the past few months, I have been working with a file using Powerpivot, and until recently the data was populating the table as it should. Recently, a change was made to the data model that redefined some of the fields within the data model. As of today, the link between my main data table...

Hi all I am new to PowerPivot and data models, and I am querying an SSAS cube in a PowerPivot data model. I have a problem with duplicate names inflating figures. The duplicates come from a Project Server SSAS cube. <tbody> Row Project Name Cost 1 1004 - Parent Project £500 2 1004 - Sub...

Hi, I have searched everywhere and cannot seem to find an answer to this issue. I have a couple of pivot tables built from a powerpivot query of a database on one of our servers. These tables are showing similar information so i have applied a couple of slicers, such as owner and business...

I have several tables in a relational DB format in PowerPivot. One table contains the sales for each item. Another Master table contains a list of families. I would like to create a Pivot table column (PowerPivot) with an expression that shows the SUM OF SALES BY FAMILY for each row of item...

Hello I´m having problems counting properly with a calculated field. (Excel 2013 64b on win 7 64b) The current calculated fields are: [Max CLOSE 1 Week] =IF([Sum of...

Hi, I want to connect 3 tables by Power Pivot and receive “Relationship may be needed?” . 1 with columns: Origin, total events 2 with columns: Origin, Deposits 3 with columns: Origin, total events Relationships: 1. Second-Origin to First-Origin 2. Second-Origin to Third-Origin Results: By each...

I am trying to learn powerpivot and wanted to know the best way to set up my data. I get an extract of student test data in a spreadsheet. It has the student name, id, grade, and the test scores for a given test. Each time they take another test, it adds a row of data. At the end of the...

Hi Guys, I'm working in PowerPivot 2013 and need some help. I have a large table of transactional customer data (ordered by transaction date) that includes a number of different fields. Based on my years of data I want to determine if a certain characteristic 'HasCharacteristic' is met by a...

Hello, I have a few macros that work well in pivot tables in Excel 2013. For instance they adjust all titles in the pivot table, or set all value items to sum - simple but helpful macros like that. Macros are found on internet or books and adjusted to make them work for my situation. Using pivot...

Goal: To create a visualization that ranks my cities based on the filters I click on the other graphs in my Dashboard; displayed as a percentage. Background: I have 50 cities. Each city has supplies (ex: notebooks, pencils, pens). However, some of the supplies are broken. I have a pie chart...

Hello, I am having a had time having this function work properly. I am creating a proper P and L sheet using powerpivot. Meaning I want both my expenses and revenue as positive value on the sheet. Right now the revenue show up as negative and expenses as positive. So I need to make the Revenue...

Dear Mr Excel! I HAVE purchased your 2010 data analyst book and have found it really helpful, and due to problems with integration between powerpivot 2010 and power query 2010, upgraded toEXCEL 2013. I have a trial version at the moment. When I click on data model I am getting an error message...