Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: Creating measure selecting latest date and time

    Hi,

    To filter on the 'maximum' value of any column within a DAX measure, the LASTNONBLANK is a convenient way of doing this:



    Price at latest time =
    CALCULATE (
    AVERAGE (...
  2. Re: DAX Calculated Column, Multiplying Order Changes Answer?

    You're welcome Mike :)
    All the best,
    Owen
  3. Replies
    4
    Views
    668

    Re: Change column type from a list of types?

    That's good news :)
    I also have Chris Webb's book, but that is probably a similar level to M is for Data Monkey.
    I hear Gil Raviv's book is quite good. It covers some specific analytical examples...
  4. Replies
    4
    Views
    668

    Re: Change column type from a list of types?

    Hi macfuller

    Try changing
    Expression.Evaluate
    to
    each Expression.Evaluate(_, #shared )

    Adding #shared allows Expression.Evaluate to access functions/types etc from the global environment,...
  5. Replies
    4
    Views
    577

    Re: Forecasting Opening and Closing Inventory

    Hi again gkaropo,

    It sounds like you're using Excel 2013 - I should have checked :)
    In the Excel 2013 version of Power Pivot, the MIN function only works with a single column but not with two...
  6. Replies
    4
    Views
    577

    Re: Forecasting Opening and Closing Inventory

    Hello gkaropo

    Welcome to the forum :)

    I have uploaded an edited version of your file here.

    The logic I have used here (and in similar situations in the past)

    Based on the original...
  7. Re: Power Query: Using a Text Parameter to Return a [FieldName] List

    Hi Jerry,
    You can use the Table.Column function to refer to a column using its name as text.

    In your example, [FY19] is shorthand for _[FY19], and you can get the same result with...
  8. Replies
    3
    Views
    594

    Re: Average with topn

    You're welcome :)

    The two expressions should both return the same result in this case, but ADDCOLUMNS/SUMMARIZE is generally considered best practice.
    See here:...
  9. Replies
    3
    Views
    594

    Re: Average with topn

    Hi sadath,

    Try this instead:

    AvgTopSales:=
    CALCULATE (
    AVERAGEX (
    TOPN (
    2,
    ADDCOLUMNS ( SUMMARIZE ( Table1, Table1[Parlour] ), "TotSales", [Tot] ),
  10. Re: please help with using LEFT function inside the DAX

    Hi flora1,

    I can see two fixes to make here:

    You don't need the VALUES function. Since FILTER iterates through the rows of DATA, you can use a direct reference DATA[Serial] to refer to the...
  11. Re: DAX Calculated Column, Multiplying Order Changes Answer?

    You're welcome Mike :)

    After re-looking at the SQLBI article, the problem can only arise when Currency & Decimal types are combined in a multiplication or division. All other combinations appear...
  12. Re: DAX Calculated Column, Multiplying Order Changes Answer?

    Hi Mike,

    The underlying reason for the difference is that the column dProducts[StandardCost] is of type Currency (aka Fixed Decimal Number), while the other columns are of type Decimal.

    In...
  13. Replies
    1
    Views
    354

    Re: Need help creating an aging measure

    Hello ndbwhunter,

    What you're wanting is basically an 'events in progress' measure, where you are counting claims that are somewhere between Notification Date + 31 and Decision Date as at the...
  14. Replies
    2
    Views
    1,064

    Re: Power Query Sort Ascending, Null Last

    Hi there,
    Another suggestion:
    For the second argument of Table.Sort, you can provide a function that maps a row of the table (i.e. a record) to the value to be sorted. You can provide a function...
  15. Replies
    1
    Views
    297

    Re: PQE formula using AND & OR

    Two problems I can see:


    DateTime.LocalNow should be DateTime.LocalNow()
    Rather than comparing datetime values with the empty string "", you may want to compare with null instead. It seems...
  16. Re: Clicking between Power Query Window and Excel

    Hi Andy,

    Unfortunately the experience is the same with Power Query within all versions of Excel from 2010 to 2016 - the Power Query window must be closed to navigate the Excel workbook.

    I just...
  17. Re: Multiple rollups by different aggregations in same table

    Hi there,

    With your Vouchers table structured the way it is, this is a possible measure, that would ensure each Check Number ends up in one segment only:


    Actual Payment By Period :=...
  18. Replies
    2
    Views
    397

    Re: Weird Sum DAX help...

    Hi there Matty,

    I would do something like this:


    Weird Sum =
    SUMX (
    SUMMARIZE ( Sales, Sales[Week], Sales[Shop] ),
    CALCULATE (
    MAXX ( VALUES ( Sales[Type] ), CALCULATE (...
  19. Re: PowerBI Comparison between dynamic daterange.

    Hi Jaagz,

    Ensure you have a standard 'Date' table with contiguous dates related to the Date column in your SalesTable.
    I will assume you have a measure like [Sales Amount] already.

    Then define...
  20. Re: DAX Formula for a suggested value - would use index/match if not using DAX

    Hi Vaslo,

    If you want to do this with a DAX calculated column, something like this should work:


    Suggested Item Number =
    IF (
    NOT ISBLANK ( Data[Item Number] ),
    Data[Item Number],...
  21. Replies
    5
    Views
    692

    Re: Measure can't decide if it's a date??

    Hi there,
    I'm guessing the original problem of getting [Production Start Date] to be type date comes from the fact that the tblDefaults[Value] column contains multiple data types, so probably ends...
  22. Re: Count only unique rows with a single matching value

    Hi macfuller,

    Here's an idea for a measure that to return a count of Vendors whose only Methods are within the current selection, i.e. vendors with no Methods outside the current selection:


    ...
  23. Re: PQ Easiest Way to Set Table2 Column Types equal to Table1?

    Hmm...I can see that using Value.ReplaceType may change the table's type, but the values in any given column do not automatically adjust to that type. Is that the problem you are seeing?
    For...
  24. Replies
    2
    Views
    541

    Re: “Frequent Caller” metric

    Hi JCovelli,

    If you wanted to handle this through a measure, here's how I would approach it.

    Let's say you have a Calls table with columns Date and Member.

    I would look at each call a Member...
  25. Re: PQ Easiest Way to Set Table2 Column Types equal to Table1?

    Hi,
    Yes that's right, you should to use Value.Type to get the type of Table1.

    The full syntax to replace the table type is:


    = Value.ReplaceType( Table2, Value.Type( Table1 ) )


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