I have a table which has captured multiple actions taken by users for one Application. A single application can be submitted, rejected, and accepted multiple times. For this process I would like to generate a single ID. However, after the application has been accepted, the user can resubmit the same application ID and I want to generate a new ID for this submission. Below is my table which has been pre-processed: 
The tabled has been grouped by the "Application ID" and sorted by "Date". I created a conditional column that flags when the start of a new submission: "Is New Submission". When "Previous User Action" = Accept and "User Action" = Resubmit, this would indicate as True (highlighted blue). My goal is to create the "Desired Submission ID" column. When the user submits the application the first time, an ID is generated. And after it's been Accepted and Resubmitted again, this would generate a new ID. Is this achievable with DAX? Any help is appreciated. Thank you!
from Recent Questions - Stack Overflow https://ift.tt/3FFrVNt
https://ift.tt/33MeVZ6
No comments:
Post a Comment