Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    1,010

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

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

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

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

    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:=...
  6. Replies
    1
    Views
    475

    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...
  7. 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...
  8. 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%+.
    ...
  9. Replies
    0
    Views
    375

    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:=
    ...
  10. 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...
  11. Replies
    3
    Views
    639

    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.
  12. Replies
    22
    Views
    1,734

    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!
  13. Replies
    22
    Views
    1,734

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

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

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

    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...
  17. Replies
    19
    Views
    1,852

    Re: Power Pivot Measure Assistance

    Glad to help. It's Friday - knock off work.
  18. Replies
    19
    Views
    1,852

    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
  19. Replies
    19
    Views
    1,852

    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...
  20. Replies
    19
    Views
    1,852

    Re: Power Pivot Measure Assistance

    My bad on the measure. Try this:

    Ancil Duration :=CALCULATE (
    SUMX (
    Visits,
    VAR DurationMax =
    IF (
    Visits[CPT Code] = "70000"
    ...
  21. Replies
    19
    Views
    1,852

    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...
  22. Replies
    19
    Views
    1,852

    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...
  23. Replies
    19
    Views
    1,852

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

    Re: DAX Powerpivot Formula Lastdate

    Is there a reason you can't use the LASTDATE formula? Is this for a column or a measure? If a column you can use the EARLIER command.

    New Column =CALCULATE (
    LASTDATE ( query[Last_sale_date]...
  25. Replies
    19
    Views
    1,852

    Re: Power Pivot Measure Assistance

    Interesting. It's a bit hard to read the nested IFs in your Ancil column but offhand it seems like if a bunch of matching conditions are true you want to total the equivalent Merged Duration values,...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4