My Data is shown below. I need to meet two conditions which are
1.For each number the first group of the date should get updated in to updated Date field.
2.Whenever group(AA) is changed to new group(AB) for each number, the one before row date should get updated in to updated date field like shown below. Please help on this?
Try this formula in the Multirow formula tool....grouped by Number:
If IsNull([Row-1:Number]) then [Date]
Elseif [Group] !=[Row-1:Group] Then [Row-1:Date]
Part time Tableau, Part Time Alteryx. Full Time Awesome
Thanks for the above reply and it helped me.I have one more question. I have two dates in format like YYYY-MM-DD hh:mm:ss. I need to subtract the two dates which in format YYYY-MM-DD hh:mm:ss. Can you please help on this? Thank you!
Have a look at this page! This may be able to help