lookupvalue

Hi, I have 2 tables: SalesGOALSAppend, has LOCATION and SALES GOAL and DATES EWCHoursBudget, has LOCATION and SALES GOAL and HOURS BUDGET I would like SalesGOALSAppend to look up in what the EWCHoursBudget are when SALES hit a number. So if sales at 9100 in SalesGOALSAppend hit $100,000 look...

Hi all I need some help on PowerBI Im trying to lookup a value from another table, except that other table has multiple rows with the same value that im looking up. This ofcourse results in an error. Each row has a 'createdon' date, so I thought it would be best to lookup the row with the...

Hi Guys (and woman), I've been wandering on this forum for a bit now but cannot find the answer. I'm a bit of a newby when it comes to power bi/power pivot so I hope you can help me out (I'm using power pivot bytheway). What I would like to have is the following: I have a look up table with 4...

Good Afternoon, I am wondering if its possible to use a lookupvalue as per below with a difference ISU - where all letter date is refidc - specific ref id currently using...

Could someone tell me why I'm getting a type mismatch error on this code? I've been messing with it for hours and I can't figure out why. Sub Macro1() Dim LookupValue As Double Dim VLookupResult As Double Dim myTableArray As Range LookupValue = TimeValue("5:00:00 AM")...

I attempting to use PowerPivot to calculate our group standard cost across a number of plants globally. The trick is that often we have intercompany (inter-plant) materials whose standard cost is that of the selling plant's. The calculation of this is causing some circular references, despite me...

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

Hi I'd appreciate any pointers on this, I need to look up in PP a value based on a range in another PP Table. I want to return 'BAND' based on where Revenue in the first table falls between High and Low Band Values in the Band Table...

I'm able to create the value I need using a calculated column and the following formula: "=LOOKUPVALUE([Total Volume],[Time],"YTD Dec 2014",[Location],[Location]" I'm trying to create the same result for each record using the "Calculated Field" functionality to conserve space and not create a...

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 All, I've been struggling with an issue and was wondering if anyone might lend some guidance. 3 tables exist in my data model... I. Store, ProductCategory II. Store III. Store, UnitSales, DollarSales A many to many relationship exists between tables i & iii via ii. I am...