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])
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
2 years ago

Hi, Mark_Adams 

 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.