Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Luis
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThanks , I found other way to calculate what I was looking for.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |