Adding a column for first time transaction

[Anonymous]

First_Transaction_Table

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 this column as a filter/slicer in my report so that I can see what products customers are buying on their first visit and what they are buying other times. 

Thanks!

[az38 · Accepted solution]

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]

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