Forum Discussion

PCHMarc67's avatar
PCHMarc67
Frequent Visitor
4 years ago
Solved

Last Date based on ID grouping in Table Dax Measure

Hello!  New to BI and this forum I have a table with customer ID's and their last activity date.  I can drag this date field into a Card and set it to "latest" and by clicking on a visualization of ...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi PCHMarc67 ,

     

    Maybe you can try this expression:

    Measure =
CALCULATE (
    MAX ( 'Table'[Action Date] ),
    'Table'[Constituent ID] = SELECTEDVALUE ( 'Table'[Constituent ID] )
)

    Then you need put the name field in the table firstly to group the table.

    Result:

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

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

PCHMarc67's avatar
PCHMarc67
Frequent Visitor
4 years ago

Let me Clarify... this is what the source table looks like.  lots of rows repeating my people.  So I want to create a measure that would group by Constituent ID then return the last Action Date (10/8/2021)    thx

 

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi PCHMarc67 ,

     

    Maybe you can try this expression:

    Measure =
CALCULATE (
    MAX ( 'Table'[Action Date] ),
    'Table'[Constituent ID] = SELECTEDVALUE ( 'Table'[Constituent ID] )
)

    Then you need put the name field in the table firstly to group the table.

    Result:

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

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

    • PCHMarc67's avatar
      PCHMarc67
      Frequent Visitor
      4 years ago

      This is perfect!  thank you