Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
I am in search for solution to my problem. I believe somebody must have had the same or similar situation therefore your help is greatly appreciated.
I have a table with one date column which consists of date and time and other rows specifiy the activity in the process, it is P2P.
Please find attached below what I have in white table and yellow is what I would like to have.
Many thanks
Solved! Go to Solution.
@Anonymous ,
It works on my side as below, could you please share the sample data for further analysis?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
Create an index column in query editor and then create a calculate column using dax below:
Timestamp END =
VAR Current_Index = Table[Index]
RETURN
CALCULATE (
MAX ( Table[Timestamp START] ),
FILTER ( Table, Table[Index] = Current_Index + 1 )
)
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yuta-msft
Thank you for the tip. Although I do get the dates in the Timestamp END, the dates I get are the same as the Timestamp START.
Seems that the part with Current_Index + 1 does not work, or at least not as it should. Do you have an advice how to solve this? If needed, I can also provide an example excel sheet.
Many thanks
@Anonymous ,
It works on my side as below, could you please share the sample data for further analysis?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |