calculated column

Hi all, I am trying to create a calculated column to return a distinct count of "ID" based on two filter conditions: 1) "Person ID" is equal to "Person ID" of current row. 2) "Start Date" is within L12M from "Start Date" of current row. I've got 1) to work, but cannot get 2) to work. Here's...

Hi, I'm creating a financial model where a "Product" will be launched several times over the coming years. The Product will have a predictable financial profile but I'm trying to build in flexibility to run scenarios where we specify how many of these products are launched in a given year. I'm...

Hello All, I have a pivot table into which I would like to total certain columns. The pivot table is structured as follows: <tbody> This is what my pivot table looks like 0000 0000 Total 0215 0215 Total 1001 1001 Total Grand Total OPCP CFP OPCP OPMA CFP...

Hello there! So I'm trying to create a query in Access that will have a calculated column that compares the first 2 columns and return True if the first column number is less than the 2nd column number. how would i go about doing this? tricky thing is, the first 2 column headings change based...

Hello, Is there any way to create a calculated field when there is multiple columns in pivot table? there is two fields inserted in to column section and use the number from there to create calculated field. I am trying to create Rev Prod- cost 1 field. For example: Data would look like this...

Hi Firstly, I need to achieve the following within PowerQuery (shockingly my employer still uses Office 2010) and not a fan of PowerPivot in 2010 (too easy to break the model!). In my PowerQuery I will be providing various rankings for based upon multiple conditional columns, what I then need...

Hello, I need assistance creating a PY Revenue measure without a calendar table. Prior Year Revenue is the calculated measure I need to create. <tbody> Sales Year Revenue Account ID Prior Year Revenue 2017 $1234 11231 $36 2017 $123 213 $165 2017 $754 505 $1324 2017 $36 11231 0...

Hello, I am to figure out if it is possible to use a calculated column in a measure. The Calculated Column counts number of accounts per user: #ofAccounts =IF(ISBLANK(CALCULATE(COUNTA(Accounts[Contract Id]),FILTER(ALL(Accounts),Accounts[Contract Id]=Contracts[Contract...

I'm receiving this error both in a larger data model and a simplified model. I have two tables in the data model, a 'quantity' table with a date column containing the first date of each month in a year and an associated quantity and a contiguous three-year 'calendar' table that extends a year...

I think this is an insanely easy problem to solve, but I am not positive how to go about it correctly. Here is the scenario. I pull the same report every day. This report compares the previous day's report, stored in Table1, and compares it to the current day's report Table2. This report has an...

Hey guys. I have a challenge that has me stuck. I have a data dump of bank transactions. The simplified data looks like this: <tbody> OpeningLedgerBal Debit Credit EndRunningLedger 250 10 320 250 10 340 250 10 300 250 100 350 250 10 330 250 10 310 250 10 290 </tbody> My...

Hello, Formula works in excel .. but not in sharepoint. Not sure i've posted in correct forum for sharepoint, i viewed similiar thread in this forum. Need to extract total business hours worked between 2 dates\time (Date and time format)...

Afternoon, I'm really hoping someone can assist with the formula/calculation to insert a date when one date is missing between the two dates I'm trying to basis the calculation on. My table [fCompletedPRs] contains information related to procurement requisitions submitted and worked in our...

Is it possible to reference a *cell* in a calculated field of access? I want to add a column that takes the average of the "price" column, if the "product ID" column matches the "product ID" of that row, and the "date" column is less than the date in that row. <tbody> No. Product ID Date...

Hi, I am having trouble adding a calculated column to my pivot table. I have 2 tables of data on spreadsheets in the workbook. Table 1: Participation by Program, Table 2: Census Population Data by Zip Code. I am trying to find the % total participation for each zip code. To do this I...

Hi There, I'm showing the % of subtotal in the Pivot Table. But How do I make the Subtotal appear as a % of itself, and not of the grand total? Essentially, I want the items in the subtotaled section to be a % of subtotal (which I've done), and the subtotal to show as % of itself (ie:100%)...

I need help creating a percent complete column on the right of a pivot table. I have status as a column that posts all of the statuses (Overdue, Complete, Future) horizontally and a Grand total column on the right. I would like a % complete column to the right of the grand total column that...

I have 3 tables, the fist is the FactTable, the second is the Calendar table and the third is the DailyFx table, which lists the exchange rate for every single day of the year. I am trying to come up with a calculated column in the FactTable that for every row it will give me the average...

I did a search on this error message on this forum but am surprised to find no one has provided a clear or any answer from what I can see. It's very simple. I have two tables that are related together using an numeric ID field. All good. Table A is the "one" side of the one to many relationship...

I have a table with sales of individual products, along with their sales order ID. I want to add a calculated column that will indicate if a certain product was contained in the sale. It might be easier to give an example. In this example I want a calculated column that will indicate if the sale...