Average values in the same column.

[jopaqui]

Originally, I had a column with values every second.  I converted the timestamp column from HHMMSS to HHMM. Now how can I average the values that belong to the same HHMM. Can somebody please help?

thank you

Jorge

[Greg_Deckler]

Also, a sample of your data would be tremendously helpful, did you add a column in Power Query when you converted to HHMM?

[jopaqui]

Yes, I added the column on the right hand side (SAMPLETIME_UTC BY MINUTES). Is this screenshot good enough or you need the file I am working with?

 I will try your solution and let you know.

thanks a lot

Jorge

[dax · Accepted solution]

Hi @jopaqui , 

It seems that you want to get average of same timestamp, right? You could achieve this like below(group by on "SAMPLETIME_UTC BY MINUTES")

Best Regards,
Zoe Zhi

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

[jopaqui]

Hello Zoe,

 I tried the Group by and it worked.  It was very simple and effective.

thank you for your help.

Jorge 

[Greg_Deckler]

I was just helping someone with something similar a short while ago, see if this works: https://community.powerbi.com/t5/Quick-Measures-Gallery/Mind-the-Gap-Irregular-Time-Series/td-p/9917...