power pivot 2016

  1. C

    CUBEVALUE

    I brought in a table and loaded it to data model. I created a pivot and then used OLAP tools to convert it to Cube formulas (allowing me to insert columns, etc where a pivot table won't let you). My problem arises when I bring in the next month's data. I've written the formula that hould work...
  2. G

    Power Pivot guidance - data structure and avoiding many-many relationships

    Hello, I’m looking for some guidance on how to build my data set, so I can effectively use Power Pivot to present my results. In my attempts so far, I have come up against the challenge of many to many relationships when trying to create relationships between my tables. I have tried to create...
  3. K

    Data transformation (using Formula) in Power pivot for data source from Folder

    Background: I've configured a PowerQuery to automatically fetch a sales and forecast dataset that updates monthly. So, the dataset gets arranged based on the Source File which gets refreshed on a monthly basis. Example: Feb'19 Dataset: Has Jan'19 Sales Actuals and Feb'19~Dec'19 Sales...
  4. J

    Refreshing Queries using VBA - Message Alert for Queries that Failed to Refresh

    Hi, I have the below code that refreshes a workbook that uses a power query data model as it's source. My issues is that, even when the queries fail (if another person has one of the source workbooks open, the file path is wrong for one of the query connections, I have a many to one...
  5. M

    Finding Latest Supervisor

    Hi All, I have a quick question regarding PowerPivot calculate column. I have below tables 1) Transactions <tbody> EMP ID EMP Name Sale Amount Sale Date Supervisor Name 1 xyz $1000 12/12/18 Sup 1 1 xyz $100 12/15/18 Sup2 </tbody> 2) HeadCount Table <tbody> EMP ID EMP NAme SUp Name...
  6. A

    How to calculate an average of two fields in power pivot table?

    Hi all, I have such a basic question that it pains me to even ask, but I just can't crack it. I use pivot tables extensively and have the following problem: Source data: <tbody> Day Cost Revenue Return on investment 1 30 0 0 1 10 0 0 1 400 2000 5 1 23 0 0 1 50 1000 20 </tbody>...
  7. S

    Powerpivot IF or Isblank Formula Help

    I am attempting to write a formula and getting a syntax error and looking for help. I have a related column coming [quantity late] that is either blank or has a number. I am trying to say if the column [quantity late] is blank or 0 put a 0 in my new calculated column otherwise divide. My...
  8. T

    Many-to-many Relationship Error

    Hello all. I am new to Power Pivot and am taking my first stab at it by uploading multiple data sets that show net revenue received for each company. I am having a difficult time creating a relationship between the net revenue columns for each data set. Instead, I receive an error saying "Net...
  9. S

    Flagging the current record in a table

    Hello I need help converting excel logic to Power Pivot formula. I have a list of supplier names (each have a unique ID, a supplier name and a status). The problem is that a given supplier can actually have multiple records ie - same name but different status record and different ID. Here's...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top