Could you please attach mocked up sampled data as twbx.
Thanks Prasanna! That's what I needed., Now if I can only figure out how to make New Status Date an aggregate measure so both measures are aggregate...
Jeffrey, not sure of the exact structure of your data. You can get count of the date instead.. If you can pass a masked data set I can help you out.. (as in replacing sensitive info with dummy data)
Thanks Prasanna. A coworker helped me with the formula to convert the date into a non-aggregate number 1 to match the other non-aggregate value in the formula you gave me, so now I don't get a aggregate vs non-aggregate error.
IF ISNULL ( [New Status Date] )
Have a good one!