Forum Discussion
RGI
Helper III
Helper IIIAverage of Time column
I have a few Time columns in MSSQL. I'm hoping to display these with their AVERAGE in a table. The actual times on the rows are correctly displayed, but no option to display a final total (AV...
See if this article helps:
https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
RGIHelper III
Helper IIIMy solution so far:
1) I changed the [Time] column in the database to [Int] (seconds).
2) I implemented a new measure as
Average Time to Empty Bin = TIME(INT(AVERAGE(Wave[Average Seconds to Empty Bin])/3600),INT(MOD(AVERAGE(Wave[Average Seconds to Empty Bin]),3600)/60),0)
This now shows the correct data in the column and a nice average in the total row.
However, as I've posted in this thread my slicers have stopped working.