Forum Discussion

Daretoexplore's avatar
Daretoexplore
Icon for Advocate I rankAdvocate I
1 year ago
Solved

Most recent entry for a person

Hi all   I have some data which is customer and transaction based, like this.   CustID.         TransactionDate.         Amt 12345.          1/12/24.                      £32.45 12678.         ...
Need Help
  • johnt75's avatar
    johnt75
    1 year ago

    You could create a column like

    Is Latest Date =
VAR LatestDate =
    CALCULATE (
        MAX ( 'Table'[Transaction Date] ),
        ALLEXCEPT ( 'Table', 'Table'[Customer ID] )
    )
VAR Result =
    IF ( LatestDate = 'Table'[Transaction Date], 1 )
RETURN
    Result
Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
1 year ago

Daretoexplore 

 Create a New Calculated Column

IsMostRecentTransaction = 
VAR LatestDate = 
CALCULATE(
MAX('YourTable'[TransactionDate]),
ALLEXCEPT('YourTable', 'YourTable'[CustID])
)
RETURN
IF('YourTable'[TransactionDate] = LatestDate, 1, 0)

You should see a 1 for the most recent transactions for each customer and a 0 for others.

 

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn