Forum Discussion
Calculate mode from a data table
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.
the following is my sample,
1. create a new column to transfer the time to minutes
Minutes_TIME = HOUR('Table'[TIME])*60+MINUTE('Table'[TIME])2.Then create two measures:
AVG_TIME = AVERAGEX(FILTER(ALL('Table'),[SUB ACTIVITY]=MAX('Table'[SUB ACTIVITY])),[Minutes_TIME])
MED_TIME = MEDIANX(FILTER(ALL('Table'),[SUB ACTIVITY]=MAX('Table'[SUB ACTIVITY])),[Minutes_TIME]) Output:
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.
Thank you Yolo Zhu, I understand that this solution you propose gives as a response to the average and the median.
But the data I need is fashion, which is the value that is most repeated.
Best regards.
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.
