Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
I have a Table called Trackers. This table shows different departments, called program areas that have Intiatives that they track every reporting period (being weekly).
I want a formula in DAX that can count how many 'Yes' under the decision required column from the latest reporting period till the count reaches a "No" from prior reporting periods. Below is the table:
not quite understand the logic, could you pls explain more and provide the output screenshot as well?
Proud to be a Super User!
Hi,
Thank you so much for your reply. I have not visualized the output yet. I will try to explain for better understanding.
1. The table is a history table that shows updates of "Initiatives" from different "Reporting Periods"
2. The "Initiatives" are "Building", "Construction", "Parking", "Moving" and "Clearing"
3. The "Reporting Periods" are in weekly basis, starting form the oldest to the current as seen in the table.
4. The "Decision Required" and "Progress Status" are updates made for each "Initiative" weekly.
5. The "Decision Required" column has either "Yes" or "No" as its value, while the "Progress Status" column has either "Complete", "In Progress", "No Progress" and "Implementation Underway" as its values.
6. My question is If an "Initiative" has a "Decision Required" value of "Yes" in the current "Reporting Period", I need a formula that counts how many times "Yes" occured consistently until the "Initiative" "Decision Required' value changes to "No'.
I need a count of all the "Yes" until a "No" and how will I be able to Visualize the Report
is this what you want?
if not , pls paste the sample data here, not the screenshot and provide the output(you can use excel to generate the output)
Proud to be a Super User!
User | Count |
---|---|
84 | |
80 | |
70 | |
47 | |
43 |
User | Count |
---|---|
109 | |
54 | |
50 | |
40 | |
40 |