Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    1
    Views
    652

    Re: Difference between MAX and LASTDATE

    Seems like LASTDATE changes the context in a way that I (and others!) didn't expect. I've found a post on Marco Russo site that explains what is happening: Usage of dates argument in a row context |...
  2. Replies
    1
    Views
    652

    Difference between MAX and LASTDATE

    Hi,
    I'm applying the following measures on a Calendar table with a [Date] column and a [Year] column:

    [Row Count With MAX] = CALCULATE(
    COUNTROWS(Calendar),
    ALL(Calendar),
    FILTER(...
  3. Replies
    4
    Views
    1,326

    Re: Question Re: Time Intelligence Functions

    In case someone gets this far... Miguel (thanks!) was able to solve this problem for me offline.

    The solution was to

    1) create a new table called 'Claims' with unique claim id/numbers

    ...
  4. Replies
    4
    Views
    1,326

    Re: Question Re: Time Intelligence Functions

    Thanks Miguel - I'm very grateful for you reply. I don't think I was 100% clear with my question, although your reply did get me to try a few more things. I think I'm getting closer!

    To make it...
  5. Replies
    4
    Views
    1,326

    Question Re: Time Intelligence Functions

    Hi,

    I'm new to Powerpivot and working my way through Rob Collie's DAX book. I've just gone through the Time Intelligence chapter and it's prompted me to look at some data I have at work.

    I...
Results 1 to 5 of 5