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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

0

There is 1 incorrect dax formula in Time in State documentation

Hi Team,

There is issue in below dax formula.(Red text code) Comparizon Operator missing

link - Add a time-in-state measure to a Power BI report - Azure DevOps | Microsoft Learn

State Rework Time in Days =
IF (
ISBLANK ( 'View Name'[State Change Count - First Completed] ),
0,
CALCULATE (
SUM ( 'View Name'[Date Diff in Days] ),
ALLEXCEPT ( 'View Name', 'View Name'[Work Item Id] ),
'View Name'[Date] <= EARLIER ( 'View Name'[Date] ),
'View Name'[State Change Count] EARLIER ( 'View Name'[State Change Count - First Completed] ),
'View Name'[State] IN {"Completed", "Closed", "Cut" } = FALSE()
) + 0
)

 

 

Status: Delivered
Comments
Anonymous
Not applicable

Hi  @Anonymous 

Thanks for your feedback ! I've brought this to the attention of the corresponding team and they will make changes to this. Thanks again for your feedback !

 

Best Regards,
Community Support Team _ Ailsa Tao