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 very grateful for your recommendations. Attached part of the table that is required to calculate the time mode for each sub activity:SUB ACTIVITYTIMEContracts, agreements and legal documents0:10:00Contracts, agreements and legal documents0:10:00Meeting with supplier0:15:00Payment process0:15:00Quote0:15:00Payment process0:15:00Review and filling of WBS, requisitions0:15:00Contracts, agreements and legal documents0:15:00Quote0:15:00Contracts, agreements and legal documents0:30:00Contracts, agreements and legal documents0:30:00Purchase Order0:30:00Quote0:30:00Validation and specification0:30:00Modify Ms Project program1:15:00Ms Project Program Review / Activities1:30:00Ms Project Program Review3:30:00Design/draw/model5:40:00Purchase Order0:15:00Purchase Order0:15:00Purchase Order0:15:00Guarantees0:15:00Guarantees0:15:00Validation and specification0:15:00Purchase Order0:20:00Purchase Order0:20:00Purchase Order0:20:00Payment process0:30:00Comparative0:45:00Validation and specification0:45:00Validation and specification0:45:00Updating indicators1:00:00Validation and specification1:30:00Quote1:30:00Updating indicators1:30:00Ms Project Program Review2:45:00Ms Project Program Review3:00:00Printing/Folding Drawings4:00:00Plano as-built4:00:00Architectural program and zoning8:00:00Design/draw/model8:00:00Quantification/Catalog/WBS8:00:00Design/draw/model9:00:00Design/draw/model9:00:00Quote0:15:00Contracts, agreements and legal documents0:15:00Purchase Order0:15:00Purchase Order0:15:00Purchase Order0:15:00Payment process0:15:00Job closure0:20:00Job closure0:25:00Quote0:25:00Quote0:25:00Payment process0:30:00Comparative0:30:00Quote0:30:00Contracts, agreements and legal documents0:35:00Comparative0:40:00Validation and specification0:45:00Contracts, agreements and legal documents0:45:00Quote1:00:00Validation and specification1:00:00Construction route1:00:00CONSTRUCTION SUPERVISION2:00:00Development of generators and volumetries2:00:00ELABORATION OF MATERIAL REQUIREMENTS2:00:00Site visit2:00:00Purchase tracking2:00:00DELIVERY TO OPERATION3:00:00Printing/Folding Drawings3:00:00DELIVERY TO OPERATION5:00:00Project request (interiors/engineering)5:00:00Design/draw/model5:00:00Design bases/criteria5:00:00Design/draw/model7:00:00Review and filling of WBS, requisitions0:05:00Review and filling of WBS, requisitions0:05:00Review and filling of WBS, requisitions0:05:00Review and filling of WBS, requisitions0:05:00Review and filling of WBS, requisitions0:05:00Review and filling of WBS, requisitions0:05:00Review and filling of WBS, requisitions0:05:00Review and filling of WBS, requisitions0:05:00Review and filling of WBS, requisitions0:05:00Review and filling of WBS, requisitions0:05:00Quote0:10:00Quote0:10:00Quote0:10:00Quote0:10:00 Thank you.

Hi Syndicate_Admin 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.

Calculate mode from a data table | Microsoft Fabric Community

Forum Discussion

Related content

Calculating modes

Direct Lake Model - Calculated Column/Tables

How to search specific word in table filter Calculations

Table Visual not Matching Calculated Visual

Directlake semantic model, calculated table