Forum Discussion
scope increase and decrease
Hi Anonymous ,
Please new a measure:
Measure = VAR _sprint_start = MAX('Table'[sprint start]) VAR _date_changed = MAX('Table'[datechange]) VAR _days = _date_changed - _sprint_start VAR _filter = IF(_days>1,1) RETURN _filterYou can use it as a filter for table visuals or use it to get the number of conditions met.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
it should just show the row with workitems with id- 20212 as it is added on the second the day of the sprint start
Hi Anonymous ,
Please new a measure:
Measure =
VAR _sprint_start = MAX('Table'[sprint start])
VAR _date_changed = MAX('Table'[datechange])
VAR _days = _date_changed - _sprint_start
VAR _filter = IF(_days>1,1)
RETURN
_filter
You can use it as a filter for table visuals or use it to get the number of conditions met.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data