lookupvalue

  1. S

    DAX = Index and match question

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

    Lookupvalue with multiple records

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

    DAX LOOKUPVALUE with IF/OR included?

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

    lookupvalue without a RANK or better

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

    vLookup in VBA

    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")...
  6. J

    Getting around a necessary circular reference

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

    DAX - sort order transactions by logic

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

    PowerPivot LOOKUPVALUE

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

    DAX LOOKUP syntax vs. Calculated Column sytax

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

    Lookupvalue function in PowerPivot

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

    Many 2 Many Store Count Row to Field Context

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top