Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Adding a column for first time transaction

Hi, I have a table where I need to add a column which tells if it is first transaction of a customer (Is_First_Transactions). How can I acheive this given all other columns ? Idea is to use th...
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    try to create a new calculated column 

    Rank_Transaction = 
RANKX(FILTER(
'Table',
'Table'[Customer_ID]=EARLIER('Table'[Customer_ID])
),
'Table'[Date],
,ASC)

    then filter by Rank_Transaction=1

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

     

az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

try to create a new calculated column 

Rank_Transaction = 
RANKX(FILTER(
'Table',
'Table'[Customer_ID]=EARLIER('Table'[Customer_ID])
),
'Table'[Date],
,ASC)

then filter by Rank_Transaction=1

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    az38  Great solution. Ranking helped me with other things as well. Thanks!