Count

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 ...

Data Protection

Show and Tell

Tips and Tricks

eddieokonkwo

New Member

3 years ago

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