Search:

Type: Posts; User: shophoney; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    803

    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. Replies
    2
    Views
    502

    Re: Percent change in price

    Hi, i'm looking for a dax measure. Not an excel formula that would be all to easy. lol

    I've got to do things the hard way.

    Need to do a measure as it's related to payroll data.

    And the...
  3. Replies
    1
    Views
    516

    First date within 2 tables

    Hi I have 2 payroll tables MAIN and MGMT. They both have dates and are linked to a common calendar table.

    I would like to know the first date you were paid from both tables.

    You could only show...
  4. Replies
    2
    Views
    502

    Percent change in price

    So I have an item that we have received many times and would like to create a table using a measure listing percent change and date.

    IE received at $1 Jan 10 then oct 8 $1.25 then nov 22...
  5. Replies
    0
    Views
    349

    TOP 100 by month, need help.

    Hi, I've created a PowerPivot DAX measure to list my TOP 100 Brands. I would like to find a way to see for the month of May 2019 vs 2018 vs 2017. The measure below shows me each year total compared...
  6. Replies
    0
    Views
    246

    New PC purchase

    Hi all, looking for advice on a purchase.

    I currently have a Dell 8930 with 64gb ram, I7, m2 ssd.

    Looking to gain speed. I was thinking of getting an i9, with the same specs above.

    My...
  7. Replies
    2
    Views
    581

    Power Query Unpivot?

    HI, I have a power query table with payments made on a transaction. I would like to have all payments on one line for each transaction so I can link them to the sales table.

    But if a customer paid...
  8. Replies
    1
    Views
    519

    Count of new customers

    Hi, I'm trying to figure out each month what new customers we have.

    I have a table called tblCustomer what has a date created.

    I have a table sale with sales dates.

    I would like to create a...
  9. Replies
    3
    Views
    154

    Re: Vlookup using wildcard

    Hi, thanks for the reply.

    Maybe my example wasn't clear.

    Column "C" is the Vlookup formula.

    In your formula what is the "3", after the "A2"?

    When I paste your example. I get a "0". I...
  10. Replies
    3
    Views
    154

    Vlookup using wildcard

    Hi, I have a credit card bill that i export.

    I also have a lookup table.


    <tbody>
    taxi1234
    100
    #6070
  11. Replies
    3
    Views
    149

    Re: Search and Replace close matches

    Sorry, no.

    I'm just importing data right off our credit card statement.

    Looking to grab all the Amazon charges and variations there of, and just upload them as Amazon.

    Thanks
  12. Replies
    3
    Views
    149

    Search and Replace close matches

    Hi, I'm importing data from our credit card bills. I want to bring the data into our accounting system.

    We have an issue when the names are not always the same. IE Shell 1234 and Shell 4354. I...
  13. Replies
    2
    Views
    422

    Re: PowerPivot table Multiple subtotals

    Hi, I'm not sure I follow how to do this. My data comes from an SQL connection to our server DB.

    I have built many powerpivot reports but need to add subtotals to the report.

    So I have total...
  14. Replies
    2
    Views
    422

    PowerPivot table Multiple subtotals

    Hi, I'm wondering is it possible to have a power pivot report table that has the details of units sold by one criteria. Then also shows multiple subtotals at the end.

    IE: Total units sold by Brand...
  15. Re: Pivot table based on a pivot table table

    Hi, I cant use a calculated column as the measure is based on the total sales for all units within the style.

    I first need the total sales for all sizes and colors within the style.
  16. Pivot table based on a pivot table table

    Hi, is it possible to create a pivot table based on the results of another pivot table.

    I have an inventory table that has items and a measure that calculates slow movers and fast movers based on...
  17. Replies
    1
    Views
    366

    Distinct Count problem

    Hi, I have an issue with a DAX formula and have spent over a week trying to resolve it.
    I would like to know the number of sale transactions each day. But here’s the quandary:


    If the total...
  18. Re: VBA Wildcard search for image based on a cell

    Hi thanks for the response.

    How would I be able to apply that to my current code that looks for a specific file name based on a cell.jpg

    It's quite different that what I already use. Can they...
  19. VBA Wildcard search for image based on a cell

    Hi, below is my code I use to look up products for an image. It looks in a folder for the correct photo. But we would like to now separate all the photos into sub folders, based on class.

    Is there...
  20. Filter on a Powerpivot Table (Value field)

    Hi I'm trying to filter a list of items received.

    I'm drawing the data from my POWERPIVOT. I have received items many times and need to know the # of weeks on the floor. Then I want to filter only...
  21. Dax formula to filer transfer >4 weeks old

    Hi I have a formula below that show when an item was first sent to stores.

    I need to filter only results that are <4 weeks on the floor. But since it's a value field I cant filter it.


    Can...
  22. Replies
    0
    Views
    378

    Dax IF, AND, BETWEEN DATES

    Hi, I'm trying to create a formula in DAX for:

    If location ="9000"
    And the date is between 4/1/18 and 6/30/18
    Then take the SALES_GOALS[LY CORE]*1.5
    ...
  23. Replies
    2
    Views
    603

    Re: DAX formula nested measures

    Hi, Ezee.

    I did some testing last night and I think that might be the right direction.

    I will try to test again. But our company is very busy right now and my days are limited.

    Maybe a power...
  24. Replies
    2
    Views
    603

    DAX formula nested measures

    Hi I have 3 measures. They all work fine on their own. But now I would like to have it evaluate when all 3 conditions are met.

    I cant seem to get it to work.

    MUGS UNITS SOLD:=CALCULATE([SALES...
  25. Replies
    0
    Views
    207

    Big challenge question for powerpivot.

    Ok. I hope i can explain this well.

    I need to calculate sales increase for my stall. Here's the example and I just can't figure this out.

    I want to work with powerpivot for many reasons.

    I...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4