Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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.