Need to create calculate Colum in DAX to segregate Old and new user

[vengadesh_p]

Hi All,

i have data like below table 
i need to create calculate colum in DAX to segregate Old and new user based on  "No of time used" colum 

Ex: A1 user jan/2021 he started to use facebook so he is new user for facebook on Jan/2021 after he is old user
same user started to use insta on may/2021 so he is new user for insta on May/2021 after he is old user

Raw Data:

User ID	Month Start Date	No of time FB Used	No of time Insta Used
A1	1-Jan-2021	5
A1	1-Feb-2021	6
A1	1-Mar-2021	3
A1	1-Apr-2021	0
A1	1-May-2021	4	3
A1	1-Jun-2021	2	5
A1	1-Jul-2021	1	6
A1	1-Aug-2021	1	2
A1	1-Sep-2021	5	3
A1	1-Oct-2021	3	1
A1	1-Nov-2021	6	2
A1	1-Dec-2021	2	6
A2	1-Jan-2021
A2	1-Feb-2021		6
A2	1-Mar-2021	3	3
A2	1-Apr-2021	4	3
A2	1-May-2021	6	0
A2	1-Jun-2021	3	2
A2	1-Jul-2021	0	1
A2	1-Aug-2021	4	5
A2	1-Sep-2021	6	6
A2	1-Oct-2021	3	2
A2	1-Nov-2021	0	1
A2	1-Dec-2021	4	1

[amitchandak · Accepted solution]

@vengadesh_p , create new columns like

New FB =
var _min = maxx(filter(Table, [User ID] = earlier([User ID]) && not(isblank([No of time FB]))),[Month Start Date])
return
if( [Month Start Date] =_min , "New", "Old")

New Insta =
var _min = maxx(filter(Table, [User ID] = earlier([User ID]) && not(isblank([No of time Insta Used]))),[Month Start Date])
return
if( [Month Start Date] =_min , "New", "Old")