Forum Discussion
finding Date Difference grouped
Hello there, My sample data is desired output is : i could achieve the earliest start and latest end. But couldn't achieve Date difference is as 6 . the measure i tried takes...
I'm getting error Cannot convert date to text in step
Split Column by Delimiter
Hi dejadpower ,
The split step is due to the fact that I need to adjust the date formatting. If your date is correct, you just need to refer to these steps below. Click on the gear to see the step details.
1.Add [end time2] column.
2.Group rows.
3.Add a custom column.
4.Change the [Custom] column type.
5.Remove Columns.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.