Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Trying to build a running total by hour

    Hi I'm trying to build a formula that has the running total by hour.

    I use CUBE members

    Here is the hourly cube:...
  2. Replies
    0
    Views
    40

    Running total by hour

    Hi, i'm trying to build a running total by hour.

    I have a power pivot CUBE formula for the time:
    =IFERROR(CUBEMEMBER("ThisWorkbookDataModel","[TIME].[TIME].&[1899-12-30T10:00:00]"),"")

    And...
  3. Replies
    1
    Views
    314

    Re: Figuring out current QTR

    This was omitted from my post

    =if(dCalendar[DATES]<today(),if(ROUNDUP(MONTH(TODAY())/3, 0)=dCalendar[QTR],"CURRENT QTD",""),"")
  4. Replies
    1
    Views
    314

    Figuring out current QTR

    Hi, I thought I had this resolved. But starting in October it thinks November is the current QTR.

    This is my DAX columns I created in the Calendar table.

    These are the 3 columns i created
    ...
  5. Replies
    0
    Views
    412

    Sort DAX measures random sort

    Hi, I just opened my Excel workbook and noticed all my DAX measures that were sorted into columns are now in a random order.

    I've seen this before and moved them only to find them just thrown back...
  6. Replies
    0
    Views
    311

    #GETTING DATA, DAX issue

    Hi, all of a sudden 4 of my tables wont update. They say "#GETTING DATA". Only if i go into dax and manually refresh will they update. Or if I select the QRY inside excel and refresh the workbook...
  7. Replies
    2
    Views
    115

    Re: Running total of sales prior to now.

    Hi, thanks for the response.

    My issue might be with the TIME formula being a cubemember. See below, I only need the time part not the date.
    ...
  8. Replies
    2
    Views
    115

    Running total of sales prior to now.

    Hi, I have sales by the hour. Each hour I have a cell with the total sales.

    I'm looking for the best way to have running total, but if the time is after now it will display 0.

    1pm $200 ...
  9. Replies
    0
    Views
    302

    Change the order of DAX tables

    Hi, I have 50 DAX tables. I would like to change the order of the tables. But every time I move the tables. They go back to the original order (order of when created).

    Is there not a way to set...
  10. Replies
    0
    Views
    367

    Dax need to calculate current QTD Sales

    Hi, I have a DAX formula for MTD I'm looking to total my sales YOY using QTD.

    So today is the 12 of September I need to see all sales QTD ending today and will compare them year over year.

    This...
  11. Replies
    0
    Views
    394

    DAX last date Prior to a specific date

    Hi I'm trying to figure out what the last discount was on a Prior date.

    I have the following:

    tblInvPriceDisc that has a list of all the dates and discounts for all sku's
    tblInvSkuMaster that...
  12. Replies
    0
    Views
    406

    Dax Measure of LAST DISCOUNT Amount

    Hello all, I am in desperate need of some help with rolling back our inventory and seeing what the discount amount was on a prior date.

    I have a measure that rolls back the date and I have a table...
  13. Refresh just one DAX measure based on a cell change

    Hello all, I'm looking for a way to refresh a DAX measure not the whole workbook. When I change a value in a cell.

    So if I change let's say the date in a cell I want a specific measure to be...
  14. Replies
    0
    Views
    66

    Excel VBA to refresh just 1 DAX table

    Hi, I have a workbook with many pivot tables.

    I would like a VBA macro to run when the PIVOT TABLE changes.

    I have a dax table that is based on a excel table. When I change the value in the...
  15. Re: VBA to email skipping balnk lines or totals = 0

    Hi, i think that resolved it.

    I really want to thank you for that code. It will make things look so much better than send 500 lines when only 200 are valid.

    Cheers.
  16. DAX measure produces more than TOP 15. Slicer issue?

    Hi, I'm having an issue with a DAX formula limited to TOP!%. But produces more that 15 lines. Could it be because I have a filter on the PIVOT TABLE for location. But need to add it to the measure?
    ...
  17. Re: VBA to email skipping balnk lines or totals = 0

    wow, that is great.

    Thanks a ton. I've tried to resolve this for years.

    Quick question. My screen doesn't update now till i move from tab to tab. I think I have something wrong in the code and...
  18. VBA to email skipping balnk lines or totals = 0

    Hi, below is my VBA macro for emailing a worksheet. But I would like to hide any blank lines or lines where the value = 0.

    Is there a way. My email is already 400 lines and I send it to all staff...
  19. Replies
    0
    Views
    554

    TOPn SOLD vs OH

    Hi, Iím trying to build a measure to list the TOP 10 models and what our inventory levels are for those items.
    I would rather use CUBIC formulas but since the list of the TOP items changes each day...
  20. Replies
    2
    Views
    97

    VBA to run a max of once a day

    Hi, I'm looking to have an excel file in my windows startup group and have it run when windows loads.

    But I would like to have the code ONLY run once a day.

    So if the code has already run today...
  21. Replies
    1
    Views
    120

    Copy table and paste to next empty row

    Hi I have a pivot table on sheet 1 and would like to paste values to the next empty row on sheet2.

    I need a macro that will select everything but the header on line 1 and grab the data on the...
  22. Replies
    3
    Views
    1,049

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

    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...
  24. Replies
    1
    Views
    598

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

    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...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4