Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
eddieokonkwo
New Member

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

eddieokonkwo_0-1677127285759.png

 

3 REPLIES 3
ryan_mayu
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

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

@eddieokonkwo  

is this what you want?

 

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

1.PNG

 

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

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.