Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    6
    Views
    350

    Re: Power Query - Calendar Table

    Perhaps because I have "InsertedWorkDay" as my previous step which was from my code? You should replace that, if you haven't already, with the name of your previous step.
  2. Best way eliminate rows with multiple status from a count?

    I receive data from our ERP system on vouchers that create errors. I want to have a measure that tells me how many voucher lines were closed within the last week. But... a voucher can create...
  3. Re: Excel PowerPivot Slicer - Help required to sort month chronologically

    Your date table needs a column with the numeric value for the month. Then use the Sort By feature in the Data Model screen to sort your month name according to the month number.

    Or you can use a...
  4. Replies
    6
    Views
    350

    Re: Power Query - Calendar Table

    You're asking for quite a few options here, but essentially it seems you need to set a starting point based on the date that you load the calendar and work backward.

    If I'm understanding your...
  5. Replies
    5
    Views
    619

    Re: Streamline Power Query for Excel

    Are you asking if you can keep the previous data in the data model and just import the new daily file? If so, the answer is no. Every time you execute the query it's all or nothing - all data...
  6. Re: Count left working days in current month

    If it works, use it!
  7. Replies
    3
    Views
    606

    Re: HELP! formula for OBIEE

    You don't have a lot of information here, but typically for multi-conditions if clauses you would do something along the lines of...

    SWITCH(
    TRUE(),
    [Product Family] = "custom" && [Unit...
  8. Re: Count left working days in current month

    Your CALCULATE doesn't have an operator like SUM(). Assuming all your other logic and relationships are good...
  9. Re: Rename table headings using Names in another column.

    Are the column names records in the 2nd table, or you want the column names from the 2nd table in order to use them on the first?

    If the latter, play with the Table.Schema() function on the 2nd...
  10. Replies
    2
    Views
    609

    Re: Return lowest date across two tables

    Assuming you want the column in the Membership Table...

    [Revised End Date] =VAR DeceaseDate =
    CALCULATE (
    MAX ( 'Member Table'[Deceased Date] ),
    FILTER (
    ...
  11. Re: Extract unique value from column using DAX

    If I understand your question, you want your filter to exclude all rows where the row key appears more than once and to capture the index value. What about a COUNTROWS?

    [Permitted Index] =VAR...
  12. Replies
    0
    Views
    360

    DAX for checking quantities

    I scrape the wonderful data at Brickset for showing basic DAX concepts, but I'm a bit stumped on a seemingly simple question someone posed. If I have Lego kits A, B, and C, can I create just a...
  13. Replies
    4
    Views
    1,154

    Re: DAX formula for accruals

    Do you have your last day of the month formula that you could adapt for me?

    Yes, the department itself only needs to know what is outstanding on the last day for their budget vs. actual. But we...
  14. Replies
    4
    Views
    1,154

    Re: DAX formula for accruals

    Altering the signs seems to be giving me a larger but more credible number. But, this raises an accounting issue that I don't know if anyone else has faced. This formula works on a daily basis but...
  15. Replies
    4
    Views
    1,154

    DAX formula for accruals

    I need a correct formula for calculating accruals and I hope a finance type has something ready-made as this ties me in knots. (I think everyone hates accrual accounting.)


    We calculate accruals...
  16. Replies
    3
    Views
    749

    Re: Eliminate zombie employees

    A reasonable request. I'm not sure how to oblige with an actual workbook. The data is several hundred thousand rows a month with multiple invoice types, some of which are automated and bypass human...
  17. Replies
    3
    Views
    749

    Eliminate zombie employees

    I am trying to create a simple productivity metric to show how many invoices per AP clerk we process each month. In simplified terms

    Invoice Count:= DISTINCTCOUNT([Invoice Number])
    FTE Count:=...
  18. Replies
    1
    Views
    552

    Which histogram formula is correct?

    Poking around on the web I find various formulas for creating histograms. I'm getting different results for each formula and I want to know which one is accurate.

    I have a table of purchase...
  19. Re: Can't get new measure based off other measures in Power pivot to work, please help.

    Without knowing the exact fields it's hard to say how to ignore the breeding category-species selections from the filter. Perhaps you can create a combined field of breeding category + species and...
  20. Re: Can't get new measure based off other measures in Power pivot to work, please help.

    Always glad to help the birds.

    First, I assume you have formatted the measure as a % and taken it out to enough significant digits that you're sure it's returning 100% as opposed to 95%+.
    ...
  21. Replies
    0
    Views
    389

    Grouping logic in measure

    I have a measure that I *think* is returning what I want it to, but it's cumbersome and I'm wondering if there's a cleaner way to do this. First, here's the measure:

    Count of UoM Errors:=
    ...
  22. Re: Can a Measure create more than one value?

    Maggie -

    When you say you have created measures, can you post the DAX? You're title for this thread is significant - a measure creates a single value kinda sorta, but depending on the filter...
  23. Replies
    3
    Views
    679

    Re: Audit report of changes

    Thanks for your tip. I had considered a calculated column but was worried about the performance hit. I was hoping for a pure measure-based solution but I don't know if it's possible.
  24. Replies
    22
    Views
    1,874

    Re: Adding Power Pivot Data to the Data Model?

    Wouldn't the Audubon society have some tech resources that could help you? I would think what you're trying to do would be a delight for them to help you!
  25. Replies
    22
    Views
    1,874

    Re: Adding Power Pivot Data to the Data Model?

    This is probably an imperfect analogy, but think of the data model as one of those glass boxes in the movies where the deadly virus is kept inside and you can only handle it with the rubber gloves...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4