Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I am a bit stuck, i want to calculate elapsed time between "Submitted" and "Approved by Hub" status.
They are over different rows liked by the claim #
Any help would be really apreciated
Thanks in advance
Solved! Go to Solution.
@DannyVickery wrote:
Hi all,
I am a bit stuck, i want to calculate elapsed time between "Submitted" and "Approved by Hub" status.
They are over different rows liked by the claim #
Any help would be really apreciated
Thanks in advance
You can try to create measures like
submitted time = MAXX ( FILTER ( 'Table', 'Table'[New_Status_c] = "SUBMITTED" ), 'Table'[Change_date_c] ) approved time = MAXX ( FILTER ( 'Table', 'Table'[New_Status_c] = "APPROVED BY HUB" ), 'Table'[Change_date_c] ) elapsed hours = DATEDIFF([submitted time],[approved time],MINUTE)/60
@DannyVickery wrote:
Hi all,
I am a bit stuck, i want to calculate elapsed time between "Submitted" and "Approved by Hub" status.
They are over different rows liked by the claim #
Any help would be really apreciated
Thanks in advance
You can try to create measures like
submitted time = MAXX ( FILTER ( 'Table', 'Table'[New_Status_c] = "SUBMITTED" ), 'Table'[Change_date_c] ) approved time = MAXX ( FILTER ( 'Table', 'Table'[New_Status_c] = "APPROVED BY HUB" ), 'Table'[Change_date_c] ) elapsed hours = DATEDIFF([submitted time],[approved time],MINUTE)/60
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |