Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
I am struggling with a problem calculating average days/times in Power BI Desktop.
I have the following sets of data;
My aim is to find a formula/s which will help me calculate;
Does anyone know the steps, or the DAX formula's that i can use to calculate these sets of information?
Thanks!
Solved! Go to Solution.
Hi @bgepps,
Please see the screenshot below, click the table visualization, select the Status, Diff and Average measure as Values level. You will get the expected result.
Best Regards,
Angelia
Hi @bgepps,
Based on your description, I try to create sample data and reproduce your scenario, I get the expected result as follows.
Create sample data.
Create calculate column to get the time intervals spent for each status.
Diff = DATEDIFF(Table5[Start Date],Table5[End Date],HOUR)
Create a measure to calculate the average time spent on each job status. Create table to show the result.
Average = DIVIDE(CALCULATE(SUM(Table5[Diff]),ALL(Table5)),CALCULATE(DISTINCTCOUNT(Table5[Status]),ALL(Table5[Status])))
If this is what you want, please share the sample data for further analysis.
Best Regards,
Angelia
Hi Angelia,
Thanks for your help with this, it looks promising so far.
Once i have added the measure, how do i produce the table like your example below? Apologies, bit of a BI beginner!
Appreciate your help,
Ben
Hi @bgepps,
Please see the screenshot below, click the table visualization, select the Status, Diff and Average measure as Values level. You will get the expected result.
Best Regards,
Angelia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |