Forum Discussion
hi
Hi abc_777
It is a new requirement, You can start a new post on the forum, and if my solution is helpful to you, please consider marking it as a solution.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
I have created another ticket, if you can help me as you have worked on this
https://community.fabric.microsoft.com/t5/Desktop/hi/m-p/3655583#M1195573
thx
Hi abc_777
I am confused that, based on your original information, you can to calculate time difference of Confirmed and shipped as per order_code from 8:00:00 AM to 8:00:00 PM and now you want to calculate time difference for each status, what actual output you want?
Best Regards!
Yolo Zhu
Hello Anonymous
really thank you for your quick response. I want to exclude the time that order come from 8:00:00 PM to 8:00:00 AM
and want time difference as per follows
Order code | from Order Placed to On Confirmed (min) | from order Confirmed to On process (min) | from On process to Shipped (min) | from Shipped to Delivered (min) | |
| 2.31101E+14 | 0 | 1 | 4 | 56 | |
| 2.31101E+14 | 0 | 42629 | 1 | 2 | |
really thankx buddy
Hi abc_777
1.Create two calculated columns
Rank = RANKX(FILTER(ALLSELECTED('Table'),[order_code]=EARLIER('Table'[order_code])),[created_at],,ASC)-Statusbin = SWITCH([Rank],0,[status],1,"from order Order Placed to On Confirmed",2,"from order Confirmed to On process",3,"from On process to Shipped",4,"from Shipped to Delivered")Then select the statusbin column and set it 'sort by' the 'rank' column
2.Create the meaaure I offered above(the 7th message).
3.Put the following field to the matrix visual.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
thanks buddy, it works.
but can we do seperate measure for each of
thx
Hi abc_777
It is a new requirement, You can start a new post on the forum, and if my solution is helpful to you, please consider marking it as a solution.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.