Forum Discussion

beeisabelm's avatar
beeisabelm
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Sub-grouping table and conditional column populated from one column of a specific row

I have a table of user event names and adhoc info; Some of the events have adhoc info that needs to be used to set a conditional column values for all other rows that have same user ID. How do I crea...
Need Help
beeisabelm's avatar
beeisabelm
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago
UserType and Status are conditional columns. The table is pre-sorted by UserId and TimeStamp so the events happened in the correct order. (I ommitted the timestamp column in this sample table)
 
UserType is determined by Adhoc1 value when EventName is SubmitButtonClicked. I want to populate all other rows under same UserId with same UserType value. Ex. UserId 1 will have all rows with UserType "NewUser". UserId 3 will have all rows with UserType "ExistingUser". Otherwise, null.
 
Status is Success if the event is not the last event taken by the user. Status is Bailed if it is the last event by this user. Ex. UserId 1 PageLoaded event Status is Success. UserId 2 PageLoaded event Status is Bailed.
 
I am trying to iterate through the rows with same UserId to populate the conditional column, but not sure how to utilize the keyword "Ealier". Thank you for the help. v-yuta-msft 
beeisabelm's avatar
beeisabelm
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

I was able to solve the first question with below DAX and create a new column

 

UserTypeGenerated = IF(CALCULATE(COUNTROWS(TableName),ALLEXCEPT('TableName',TableName[UserId]),TableName[UserType]="ExistingUser")>0,"ExistingUser","NewUser")

 

However, I still need help with the second one. v-yuta-msft  Can you help?