Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |