I am comparing two dates, one of which is calculated using a variable which is assigned from a user input in the front end.
This is displaying a table of initiatives, and I wish to hide rows which do not have their initiative name displayed (as the dates haven't fulfilled the requirements)
This is a measure (due to operators such as MAX), if it was a dimension I could 'hide null values' for this column. Any suggestions as to how I could get rid of them and only display rows which satisfy the above algorithm?