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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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  @Pangane 

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

This widget could not be displayed.