Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. 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...
  2. Replies
    0
    Views
    277

    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...
  3. Replies
    4
    Views
    1,053

    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...
  4. Replies
    4
    Views
    1,053

    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...
  5. Replies
    4
    Views
    1,053

    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...
  6. Replies
    3
    Views
    712

    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...
  7. Replies
    3
    Views
    712

    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:=...
  8. Replies
    1
    Views
    531

    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...
  9. 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...
  10. 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%+.
    ...
  11. Replies
    0
    Views
    383

    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:=
    ...
  12. 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...
  13. Replies
    3
    Views
    659

    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.
  14. Replies
    22
    Views
    1,792

    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!
  15. Replies
    22
    Views
    1,792

    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...
  16. Replies
    22
    Views
    1,792

    Re: Adding Power Pivot Data to the Data Model?

    I may be misunderstanding your original post, but are you trying to add data in pivot tables that were sourced from the data model back into the data model? If so, that can't be done, much as all of...
  17. Replies
    3
    Views
    659

    Re: Audit report of changes

    BTW, I'm sure someone will wonder why I can't check the audit record in the vendor file where the changes were made... We don't have audit tracking turned on for that table. There are a ton of...
  18. Replies
    3
    Views
    659

    Audit report of changes

    I would like to create an audit report showing dates when values were changed and what those values were changed to, but only one row for each date the value changed.

    We modify payment terms for...
  19. Replies
    19
    Views
    2,152

    Re: Power Pivot Measure Assistance

    Glad to help. It's Friday - knock off work.
  20. Replies
    19
    Views
    2,152

    Re: Power Pivot Measure Assistance

    Close I think. Try

    Per Diem:=CALCULATE(COUNT(Codes), FILTER(90791 etc...)) * 15 + CALCULATE(COUNT(Other codes), FILTER(everybody else)...) * 5
  21. Replies
    19
    Views
    2,152

    Re: Power Pivot Measure Assistance

    Is your per diem a single unchanging number or does it vary? In other words, you're counting column D "90791" and multiplying by 15. Are you breaking that out by the category codes so that for...
  22. Replies
    19
    Views
    2,152

    Re: Power Pivot Measure Assistance

    My bad on the measure. Try this:

    Ancil Duration :=CALCULATE (
    SUMX (
    Visits,
    VAR DurationMax =
    IF (
    Visits[CPT Code] = "70000"
    ...
  23. Replies
    19
    Views
    2,152

    Re: Power Pivot Measure Assistance

    You want to bill to the quarter hour it seems, so you're right that FLOOR and CEILING won't work. Your Excel logic is fine for DAX. You need to use the SUMX function rather than SUM so the...
  24. Replies
    19
    Views
    2,152

    Re: Power Pivot Measure Assistance

    Are the values such as Ancil and Travel mutually exclusive? If so, you should create a new column in Power Query as I provided earlier that gives a value to each row. Then you can use that column...
  25. Replies
    19
    Views
    2,152

    Re: Power Pivot Measure Assistance

    Just to be clear since you mention rows, I assume you were trying to write a measure rather than a column. If your pivot table is showing staff names in the rows the measure I provided should give...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4