Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts
need a measure that would count where a Date had been extended out by more then 3 months where issues ID has remained the same in the second column.
DATE ISSUE ID Result
01/01/21 50
01/05/21 50 Extended
01/02/21 25
01/03/21 25 No Change
Solved! Go to Solution.
@Anonymous , Try measure like
if( datediff(Max(Table[Date]) , MAXX(filter(allselected(Table), Table[ID] = Max(Table[ID]) && Table[Date] < Max(Table[Date])),[Date]), month) >4, "Extended", "No Change")
@Anonymous
you can try this dax
@Anonymous , Try measure like
if( datediff(Max(Table[Date]) , MAXX(filter(allselected(Table), Table[ID] = Max(Table[ID]) && Table[Date] < Max(Table[Date])),[Date]), month) >4, "Extended", "No Change")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |