Forum Discussion
Creating a new table from a current table
Hi, I'm wondering if anyone can help. I have a table in my BI desktop called Trip Detail. I'm trying to create a measure that calulates the average number of trucks used each week in 2021. Th...
clarkey1988 nothing is simple until you see the data and understand the problem. It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.
Hi parry2k I figured it out by creating a new table and then averaging the number of trucks each week from that. Thank you for reaching out and helping!