Count

[eddieokonkwo]

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:

[ryan_mayu]

not quite understand the logic, could you pls explain more and  provide the output screenshot as well?

[eddieokonkwo]

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

[ryan_mayu]

@eddieokonkwo  

is this what you want?

Column = if('Table'[Reporting Period]=max('Table'[Reporting Period])&&'Table'[Decision Required]="Yes","Yes","No")

if not , pls paste the sample data here, not the screenshot and provide the output(you can use excel to generate the output)