Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.