power pivot

  1. alansidman

    Want to Put Text into a Pivot Table instead of numerical data

    Have you ever wanted to put Text into the fields in a Pivot Table instead of Values. Well, I found this link where Bill Jelen shows you how using Power Pivot at the site Strategic Finance. Fairly easy to follow. https://sfmagazine.com/post-entry/ju...a-pivot-table/
  2. P

    Stuck, Need Help (please). Trying to export unstructured text from PDF to import into Excel separating/placing text into specific columns

    Hello, I'm hoping someone can help with this work project. I have experience with formulas and pivot table and am somewhat familiar with Power Query but apparently not enough for it to help me with this work project. I've been trying to find an Excel work-around for this project to simplify it...
  3. Q

    PowerPivot LOOKUPVALUE With Conditions

    Firstly, i'm not sure that LOOKUPVALUE is the right function to be using for this scenario. So please let me know if it isn't and I will change the title. I have two tables as shown in the image below. What I want to do is get Table 3 to look up table 2 and show what exercise was being done...
  4. S

    Is it possible to write queries in Excel data model for tables ?

    I have several tables (different data) in my Excel data model and I want to JOIN them with a manual sql query. Is it possible ? If it is, how to do it ?
  5. C

    creating percentile bins at weekly level for daily data

    hello BI experts, have started to play around with power pivot and power BI over the last few days. Particular case here is to create bins (measure or column, not sure!) that reflect the weekly deciles for data which is given at a daily level. There is a lot of literature written on percentilex...
  6. S

    Unable to add new line with "Enter" in Table Import Wizard (Data Model)

    Whenever I press Enter to start a new line it returns me back to Edit Table Properties. Is it a normal thing ? Is there a way to use Enter as a new line command ? na
  7. L

    Same Store Sales Analysis using Measures

    Hi everyone, I'm new to this forum but have spent a lot of time reading through other's posts, which are often very helpful. I haven't found a definitive answer to the following question and hoping you all might be able to provide some guidance. I am pretty new to Power Pivot - thank you in...
  8. E

    Excel PowerPivot Slicer - sort month chronologically

    Hi seniors, This is my second day of learning to use Data Query, PowerPivot and Slicers in excel 2016. I am trying to create an Excel Dashboard where the data is fetched from multiple excel files located in a particular folder path through a Query and then the connections are made and added to...
  9. L

    Power Pivot Error "Many to Many" Error Is Incorrect

    I have a Dimension Table and a Fact Table brought in by Power Query. In Power Query, I added a Calculated Column to each table named "Report_ID". I'm trying to create a relationship in Power Pivot for these tables, but I keep getting the error message that Power Pivot does not currently support...
  10. S

    Power Pivot IF and Statement Help

    HI All, I am trying to create a calculated column using an if/and DAX statement in PowerPivot and for some reason I keep getting errors so I am not sure if its the formula or if I am completely unable to perform what I want. My formula is below, can someone please help =IF(([Actual Order...
  11. K

    DAX Measure to compare against prior update

    I need a DAX measure that compares latest version of financial data against prior version My data table has an'asof' column to tag which version the data originates from (100K+ rows) For example, I would like to compare the full yr 2019 cash number asof Sept 2019 vs. the full year 2019 cash...
  12. S

    Dax need to calculate current QTD Sales

    Hi, I have a DAX formula for MTD I'm looking to total my sales YOY using QTD. So today is the 12 of September I need to see all sales QTD ending today and will compare them year over year. This is my MTD formula: =if(month(dCalendar[dateS])=month(today()) &&...
  13. S

    Dax Measure of LAST DISCOUNT Amount

    Hello all, I am in desperate need of some help with rolling back our inventory and seeing what the discount amount was on a prior date. I have a measure that rolls back the date and I have a table with the historical discounts by date. What I need to see is: SKU QTY DISCOUNT AMOUNT VALUE...
  14. S

    Refresh just one DAX measure based on a cell change

    Hello all, I'm looking for a way to refresh a DAX measure not the whole workbook. When I change a value in a cell. So if I change let's say the date in a cell I want a specific measure to be updated. Otherwise refreshing the whole workbook takes may staff 20 minutes. When I can go direct to...
  15. S

    "Add Measure" Isn't Coming Up (even after I select "Add Data to Data Model")

    I am trying to have texts in a value field in a pivot table, and my understanding is that creating a Measure (concatenating the text) is the best way to do so. However, I am unable to create a measure when I am in the Pivot Table, as even after I select "Add Data to Data Model" when creating the...
  16. A

    How to modify Power Pivot data connections in old workbooks? How to convert to Power Query?

    Hello, I only started using PowerPivot after Power Query was readily available. I come across example Excel/PowerPivot documents where the data is embedded into the Data Model and I don't understand how you can modify the connections. I found this cool PowerPivot example here on the forum...
  17. M

    Connection to ThisWorkbooksDataModel missing

    From what I recall every workbook I opened had this connection whether it had a data model or not At any rate I cannot see it in ANY of my workbooks. The data models are there, but none of them have that anymore I used to use it to increase the number of rows I could drill down on. Any...
  18. S

    Combine 2 tables

    Hi I have 2 payroll tables. MAIN and MGMT. They both don't contain the same fields, but do have common fields such as name, date rate... I currently paste the data from our payroll export into 2 tabs and pull them into power pivot and back down as pivot tables. But I would also like to...
  19. M

    Refreshing External Connections In Power Query

    I set up external connections to excel workbooks to load data into power query (went fine). I decide to test the refresh feature by changing some things in the source data. It won't refresh -ever. Any idea what he problem is. What's the point of having a refresh feature if the connection...
  20. E

    VBA - Create an array from Data within the Power Pivot Data Model sourced from Power Query

    Hello Everyone, I would greatly appreciate any help anyone may have on this problem, I have combed the internet looking for an answer but have only slightly gotten close so here we go.... Is there anyway possible to retrieve data from the power pivot data model that has been loaded from power...

Some videos you may like

This Week's Hot Topics

Top