Forum Discussion
Count
not quite understand the logic, could you pls explain more and provide the output screenshot as well?
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?
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)
