Forum Discussion
Solution SageMerging two rows
Super UserSujit_Thakur , Can you share sample data and sample output in a table format?
- Sujit_Thakur
Dear amitchandak sir ,
Following is my dummy raw data
Table 1 - Raw Data TableName City Start Date Start Time End Date End time Distance(KM) Sujit Pune 11-09-20 2:00 AM 11-09-20 2:04 AM 0.2 Sujit Pune 11-09-20 2:10 AM 11-09-20 2:15 AM 0.3 Sujit Pune 11-09-20 02:30 11-09-20 03:00 4 Table 2 : Allocated Distance
name Date allocated_Distance Sujit 11-09-20 45
Now when now i am using raw data table into table visual ,
it is showing as it is shown above in table 1 ,
but what i want is while showing in table visual , it must merge two rows which are recorded within 20 mins of time stamp
desired outputName City Start Date Start Time End Date End time Distance Sujit Pune 11-09-20 2:00 AM 11-09-20 2:15 AM 0.5 Sujit Pune 11-09-20 02:30 11-09-20 03:00 4 - Sujit_Thakur
amitchandak sir ,
Do you suggest making a new table in model , using Calculate table ???
Please help, - amitchandak
Sujit_Thakur , I would approach this like Continuous Streak with 20 Min. But as 2-3 are exactly 20 Min part, so is it 19 Min?
See if you can try with this approach
If this approach can work and you are not able to get a solution, I will try out.
- Sujit_Thakur
amitchandak ,
I have a very little knowledge of M language ,
Is there any work around to do this with DAX ?
