Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Team!
Can you please help me with this seeminly simple situation?
I first need to calculate the time elapsed between 2 different dates
and then have it displayed in such a way that will show me the average time elapsed in days
THANK YOU!
Solved! Go to Solution.
Please specify what the time elapsed is between 20-Feb and 21-Feb. Is it one day or two days?
You can use
, for example.
HI @speterson ,
Test the below,create a new column,as your picture provided:
Timeelapsed = DATEDIFF('Table'[Date assigned],'Table'[Date Completed],DAY)
Then create a measure:
average = CALCULATE(SUM('Table'[Timeelapsed]),ALL('Table'))/CALCULATE(DISTINCTCOUNT('Table'[Order#]),ALL('Table'))
Output:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Please specify what the time elapsed is between 20-Feb and 21-Feb. Is it one day or two days?
You can use
, for example.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
92 | |
83 | |
62 | |
62 | |
58 |
User | Count |
---|---|
159 | |
115 | |
103 | |
75 | |
66 |