Forum Discussion

Mark_Adams's avatar
Mark_Adams
Frequent Visitor
2 years ago
Solved

Latest visit based on slicer date

I have a dataset called 'CP Visits' with Case ID and Visit Date. Each case will have several visit dates. There is also a date slicer set to 'between' with dates supplied by a date dimension. I want ...
Need Help
  • Mark_Adams's avatar
    Mark_Adams
    2 years ago

    Thanks for all the input.

     

    I everntually got it sorted myself using 

    Most Recent Visit Date =
        CALCULATE(
            MAX('CP Visits'[Visit Date]),
    FILTER(
        'CP Visits',
        'CP Visits'[Visit Date] <= [Max Date]
         && 'CP Visits'[Case ID] = SELECTEDVALUE('CP Visits'[Case ID])
    )
        )

    [Max Date] was from another measure 

    = MAXX(ALLSELECTED(DateDimension[Date]), DateDimension[Date])
Anonymous's avatar
Anonymous
Not applicable
2 years ago

You don't have to, the measure will have a context filer from the slicer on the report page.

  • Mark_Adams's avatar
    Mark_Adams
    Frequent Visitor
    2 years ago

    Unfortunately I can't get TOPN to work at all. It keeps telling me the expression refers to multiple values that cannot be converted to a scalar value