The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.