Pl attach a workbook
I am not sure about next step, but just focusing grouping.
Count if value <>7 from the top of Mktg.
All table calculation need to be set as this.
Date Groups_SM_18.1.twbx 109.0 KB
Is this just for this viz? Or are you trying to save this value in order to use elsewhere?
If the former, it's pretty easy as Shin demonstrated. Much more difficult to reassign a new date at the row level. You can do this in SQL, but unsure of your needs.