please I need help with this. I have a table with tasks and their status, completed tasks have an end date.
I need a page to have a segmenter that takes the closing date (or some calculated form) and this filters the ones completed by this date but
leaves the others that do not have a date alone. Is not with the interactions because the data is in the same object (table or graph):
Example in the picture, initial table with status, a semgment,a table with what exclude etc, results.
Now if I put that, when I move the date filter from the minimum date it excludes those that do not have a date.
I already tried to generate a column that brings me the maximum closing date to put it to those that do not have it and so
I am always using this column as a segmenter, but this maximum remains static and not dynamic
ff = VARMaxAllDate = CALCULATE(Max('POA 2024'[Close Date]), ALL('POA 2024')) VAR HasClosingDate = NOT(ISBLANK('POA 2024'[Close Date])) RETURN IF(HasClosingDate, 'POA 2024'[Close Date], MaxAllDate)
or
ff = VARMaxAllDate = CALCULATE(Max('POA 2024'[Close Date]), ALLselected('POA 2024'[Close Date])) VAR HasClosingDate = NOT(ISBLANK('POA 2024'[Close Date])) RETURN IF(HasClosingDate, 'POA 2024'[Close Date], MaxAllDate)
enter image description here
help with solving the issue
ccdiazni is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.