Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

To count ocurrences between same event into a workflow

Hi All,

I wanted to count how many ocurrences happened between 2 different status into a lifecycle, for instance my lifecycle (a defect lifecycle) has the following status: Open, Assigned, Fixed, Ready for Test ,Closed.

Now, sometimes the defect goes from Ready for Test to Assigned, then I do not know how I could calculate the number of ocurrences only when a defect is moved directly from Ready for Test --> Assigned 

Please any suggest?

Thanks sin advance.


Super User III
Super User III

You need to provide some data @luis_pflucker and there has to be a field that we can count. Row positions aren't meaningful in Power BI, so there is know way to count steps between Open and Ready for example because there are no fixed positions for the rows liek you'd think of in Excel.


How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

Thanks , I found other way to calculate what I was looking for.

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors