cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

como promediar horas

Tengo una tabla con datos en horas y fechas, y necesito poder visualizarlo promediandoolo, esto se puede hacer?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: como promediar horas

Hi @aoz1963 ,

 

You may create measure like DAX below.

 

Average Hour =

Var _HourDiff= DATEDIFF(MIN(Table1[Date]), MAX(Table1[Date]), HOUR)

return

AVERAGEX(Table1, _HourDiff )

 

If I misunderstood it, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

 

Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Super User IX
Super User IX

Re: como promediar horas

@aoz1963 , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Resolver I
Resolver I

Re: como promediar horas

Hola @aoz1963 ,

 

No entiendo claramente dónde estás queriendo promediar los datos. Por ejemplo, en un componente visual en Power BI Desktop, si agregas un dato de tipo número u hora, automáticamente te puede promediar (estableciendo "Promedio" como modo de sumarizar). No pasaría esto con las fechas, pero se podrían hacer numéricas que promedian.

 

También se podría hacer una medida en DAX utilizando alguna de las funciones AVERAGE. 

 

Saludos

 

 

Si mi respuesta te sirve, agradezco el reconocimiento y también los kurdos. Gracias!

 

Highlighted
Community Support
Community Support

Re: como promediar horas

Hi @aoz1963 ,

 

You may create measure like DAX below.

 

Average Hour =

Var _HourDiff= DATEDIFF(MIN(Table1[Date]), MAX(Table1[Date]), HOUR)

return

AVERAGEX(Table1, _HourDiff )

 

If I misunderstood it, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

 

Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors