cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: Event In Progress for multi-stage process

Hi @addaline,

 

First of all let me apoligize for just replying today, but busy week.

 

I think I have made a setup that you can use please try it and then tell me what are the questions that arrive with you setup and the calculation needed to be adjusted.

 

Create 3 Columns:

All_Approvall_Dates = IF(
			FORMAT( 'Internet Sales'[Approved Date];"mm-yyyy")=FORMAT('Internet Sales'[Ready For Scheduling Date];"mm-yyyy") && 
                        FORMAT('Internet Sales'[Approved Date];"mm-yyyy")=FORMAT('Internet Sales'[Scheduled Date];"mm-yyyy");
                       TRUE();
                       FALSE()
                       ) 

Approval_2_Dates = IF(
FORMAT( 'Internet Sales'[Approved Date];"mm-yyyy")=FORMAT('Internet Sales'[Ready For Scheduling Date];"mm-yyyy");
TRUE();
FALSE()
)

Approval_Date = SWITCH(
TRUE();
'Internet Sales'[Approval_2_Dates]='Internet Sales'[All_Approvall_Dates];
'Internet Sales'[Scheduled Date];
'Internet Sales'[All_Approvall_Dates]=FALSE();
'Internet Sales'[Ready For Scheduling Date];
'Internet Sales'[Approved Date]
)

 

With this columns I'm testing if all of the dates are equal and returning the final date (if there as to be any changes in this probably it will have to do with the last column I present.

 

Them create the non active relationship between the date calendar and the Approval_Date column

 

Create the following measures and add them to your visuals:

Completed = CALCULATE (
               DISTINCTCOUNT('Internet Sales'[Estimate Number]);
               USERELATIONSHIP('Date'[Date];'Internet Sales'[Completed Date]) )

Sent_To_Customer = CALCULATE (
               DISTINCTCOUNT('Internet Sales'[Estimate Number]);
               USERELATIONSHIP('Date'[Date];'Internet Sales'[Sent To Customer Date])  )

Approved = CALCULATE (
               DISTINCTCOUNT('Internet Sales'[Estimate Number]);
               USERELATIONSHIP('Date'[Date];'Internet Sales'[Approval_Date]) )

 I admit this is a little mesy in terms of final result, I'm still trying to see how I can calculate the approved date amog the tree dates you have, please test it and tell me what you think.

 

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 55 members 1,138 guests
Please welcome our newest community members: