Forum Discussion
Solved
Calculate mode from a data table
Nice day. I have a historical data table with which I have calculated the average and median but I lack fashion. I've been searching different forums and haven't found the solution. I would be ve...
You just can remove the column I have put in measure, than the output is correct
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Syndicate_Admin , Based on what I got. You have convert time to second or minute and take avg
seconds = hour([Time])*3600 + minute([Time])*3600 + Second([Time])
You can use median or medianx
median measure= medianx(Table, Table[second])
if needed convert back to time
time(0,0,0) + [median measure]/3600*24
Thank you amitchandak, I understand that this solution you propose gives as an answer to the median.
But the data I need is fashion, which is the value that is most repeated.
Best regards.