status

5 Topics

Status & Workflow Processing Time
I have a data set of workflow approval, showing an approval step by certain individuals, and wanting to calculate the total time for approval of a workflow and the total times in which the workflow is held within a status: Things I want to calculate: - Workflow time spent in each status - Value change within each status step change Workflow Promo Start Promo end Status Cost Workflow Change Step Workflow 1 01/03/2023 31/12/2023 Step 1 50,000.00 28/02/2023 Workflow 1 01/03/2023 31/12/2023 Step 2 50,000.00 01/03/2023 Workflow 1 01/03/2023 31/12/2023 Step 3 50,000.00 02/03/2023 Workflow 1 01/03/2023 31/12/2023 Step 4 50,000.00 25/04/2023 Workflow 1 01/03/2023 31/12/2023 Step 5 50,000.00 25/04/2023 Workflow 1 01/03/2023 31/12/2023 Step 6 75,000.00 26/04/2023 Workflow 1 01/03/2023 31/12/2023 Step 7 75,000.00 15/05/2023 Workflow 1 01/03/2023 31/12/2023 Step 8 75,000.00 22/05/2023 Workflow 2 01/03/2023 31/12/2023 Step 1 25,000.00 25/04/2023 Workflow 2 01/03/2023 31/12/2023 Step 2 50,000.00 26/04/2023 Workflow 3 01/01/2023 31/12/2023 Step 1 90,000.00 25/04/2023 Workflow 3 01/01/2023 31/12/2023 Step 2 90,000.00 25/04/2023 Workflow 3 01/01/2023 31/12/2023 Step 3 120,000.00 26/04/2023 Workflow 3 01/01/2023 31/12/2023 Step 4 120,000.00 15/05/2023 Workflow 3 01/01/2023 31/12/2023 Step 5 120,000.00 22/05/2023 Workflow 3 01/01/2023 31/12/2023 Step 6 120,000.00 13/10/2023 Workflow 3 01/01/2023 31/12/2023 Step 7 120,000.00 13/10/2023 Workflow 3 01/01/2023 31/12/2023 Step 8 120,000.00 16/10/2023 Workflow 3 01/01/2023 31/12/2023 Step 9 120,000.00 18/10/2023 Workflow 3 01/01/2023 31/12/2023 Step 10 150,000.00 03/11/2023 Workflow 3 01/01/2023 31/12/2023 Step 11 150,000.00 06/11/2023 Workflow 3 01/01/2023 31/12/2023 Step 12 150,000.00 07/11/2023 Workflow 3 01/01/2023 31/12/2023 Step 13 150,000.00 09/11/2023
Solved
lukeydb_
2 years ago Place DAX Commands and Tips
679Views
0likes
2Comments
Customer status in a specific date
I have to data tables: 1. Status changes of customers: 2. Orders: I wish to add a column to Orders table which presents the customer status as of each customer at its order date, as below: Thanks in advance
Solved
akfir
3 years ago Place DAX Commands and Tips
493Views
0likes
1Comment
Finding customer status for a given date
Hi Masters, Given is a table of status changes of customers (Old Status, New Status, Change Date, Previous Change Date) as described: Also given is the column "First Purchase Date" which is constant for each Customer ID. I wish to add a calculated column which will return the customer status of each customer while his first purchase. in the example above, customer 123 first purchase date is 15/01/2022. therefore, according to his status changes dates his status while first purchase was "b" (15/1/2022 is between 01/01/2022 and 01/02/2022) thanks for helping out. Amit
Solved
akfir
3 years ago Place DAX Commands and Tips
1.8KViews
0likes
6Comments
Calculate time (days) status per item even if status goes back to previous used status.
Hello, community, I hope I can get some help on a topic I’m already struggling with for a long time. I already had some help, but the result is not what I would expect. My question is around the time a certain item was in a certain status. I have items in an overview that come in the list in a certain status and move status FORWARD but also BACK. I would like to know two things. Total Time the item is in the list is working (see column TotalDays) This is using the following code: TotalDays = VAR _closingcount = CALCULATE ( COUNT ( 'Test Data'[Status] ), FILTER ( 'Test Data', 'Test Data'[Items.Id] = EARLIER ( 'Test Data'[Items.Id] ) && 'Test Data'[Status] = "5. Closing" ) ) VAR _maxdate = CALCULATE ( MAX ( 'Test Data'[Versions.properties.Created.Element:Text] ), FILTER ( 'Test Data', 'Test Data'[Items.Id] = EARLIER ( 'Test Data'[Items.Id] ) ) ) VAR _days = CALCULATE ( SUM ( 'Test Data'[DaysInSinceStart] ), FILTER ( 'Test Data', 'Test Data'[Items.Id] = EARLIER ( 'Test Data'[Items.Id] ) ) ) RETURN IF ( ISBLANK ( _closingcount ), _days + DATEDIFF ( _maxdate, TODAY(), DAY ), _days ) I would like to know How long a has been (or IS) in a certain status. If you look at the example below, “Item A” in column “DaysInSinceStart” should all be one cell higher and the last cell should contain the time between June 9th and the today date (base on the last Column this should be September 12th) I would expect the following result (Using September 12th as TODAY) So I can report for ITEM A, on the days that it was in a certain status. The used (not providing what is expect code is:) DaysInSinceStart = VAR _predate = CALCULATE ( MAX ( 'Test Data'[Versions.properties.Created.Element:Text] ), FILTER ( 'Test Data', 'Test Data'[Items.Id] = EARLIER ( 'Test Data'[Items.Id] ) && 'Test Data'[Versions.properties.Created.Element:Text] < EARLIER ( 'Test Data'[Versions.properties.Created.Element:Text] ) ) ) RETURN DATEDIFF ( _predate, 'Test Data'[Versions.properties.Created.Element:Text], DAY ) Can anyone please help me get this right calculated? I have created a new PBIX File (In Dropbox, I’m unable to connect the PBIX (or other attachments to this post) Thanks, Emoes
Solved
Anonymous
3 years ago Place DAX Commands and Tips
2.5KViews
0likes
11Comments
Calculating Status based on Two Dynamic Dates
Hi, I would like to create a DAX measure to to define the customer sales status based on their last order date. We have 4 statuses: Active: Last Order Date between Today and Last 12 months Passive: Last Order Date between 12 months ago and 24 months ago Dormant: Last Order Date greater than 24 months ago Inactive: Never placed an order I have created a measure for Last Order Date: LASTDATE(SalesOrders[CreatedDate]) In SQL I have this created as per below, but not sure how to translate into a DAX formula. CASE WHEN LastOrder.EffectiveDate between dateadd(month,-24,getdate()) and dateadd(month,-12,getdate()) THEN 'Passive' WHEN LastOrder.EffectiveDate between dateadd(month,-12,getdate()) and getdate() THEN 'Active' WHEN LastOrder.EffectiveDate < dateadd(month,-24,getdate()) THEN 'Dormant' WHEN LastOrder.EffectiveDate IS NULL THEN 'Inactive' END AS CRMtier, Many thanks, J
ttcalendar
4 years ago Place DAX Commands and Tips
648Views
0likes
1Comment