power pivot

Hello, I'm trying to figure out how to build a calculated column with a running total of payments against an invoice. So below is an example: Invoice #3322999 is for $14,387.86. We have 2 credits against the invoice. CN3325633 $167.44 and CN 3326818 $229.32 I'd like to see the Original amount...

I have created below model. Sales-data containes 600K rows, Dcalender 750 rows, Item info 1700 rows, Customer info 2000 rows, and remaining dimension tables app 25 rows. 2 calculated columns in DCalender, all other calculations have been created with DAX measures or M language custom columns. I...

Can anybody help me why calculated field / calculated item greyed out?

Hello everyone. I'm not good at explaining stuff, but I'll give it a ago, since I'm stuck - I've included pictures, since it's troublesome to describe in text - I hope that's okay :) I have a data-sheet, from which I've created the pivot table shown below, displaying amongst other things...

Hi I would like to create some reporting packages that include different companies, but I cannot get it to work. In my example, I have: A sales table with two columns: CompanyName and SalesAmount A Company List: Company A, Company B, Company C and Company D A Reporting Package List: Package...

I am working on a budget project in Power Pivot. I have four tables. Simplifying a bit Table 1 is tblTransactions. Fields are Date, Transaction, Amount, Category. Table 2 is tblBudget. Fields are Date, Amount, Category. Table 3 tblDate. Fields are Date, Month, Year, MonthNum (for sorting)...

I am struggling to set up a measure in Excel to look up a text value from a dimension table based on a key in a fact table. I am using Power Query to import tables from a variety of data sources as connections, so there is no literal table in the spreadsheet. My fact table is CourseCompletions...

Hi I am struggling with the measure 'GrandAverage_LastYear' in the attachment below. I would like to replicate the 'GrandAverage_Selected' measure, but for 'Last Year Count'. In the workbook I have two tables, one containing unique dates and the other containing dates and a category. The aim...

Hello, I need help writing a formula for excel power pivot table please, that will subtract two calculated items from the same data table column in the pivot area. The formula will subtract "Past 4 Weeks" from "Prior 4 Weeks" as a calculated item column that will display in Column "D" and apply...

Hello everybody! As a newbie, I'm approaching Power Query and Power Pivot. After the initial successes, I am now stuck with a problem and hope for expert advice. I've already added my data to the Power Pivot data model. Date StorageLevel 01/01/2015 165.31 01/02/2015 164.98...

Very strange -- Power Pivot will not let me view my entire workspace in the Diagram View. I've saved the file, closed it out, reopened it and the "gray" area won't go away. I can't drag it back or seemingly find any way to decrease the size. The +/- zoom doesn't do anything. I've switched back...

I am working in Microsoft Office 365. ABCDEFGHIJ3Part NumberPurchase DescriptionSupplierOEMOEM Part NumberCostOn HandBldQtyPurchase RequirementsExtended4010-001Cord, power, 18 AWG, 5-15P, 9.84 ftDigi-KeyQualtek312010-01$7.00 4.0051 $ 7.00 5035-001Switch, pushbutton, SPST, 3A...

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/

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...

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...

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 ?

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...

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

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...

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...