Forum Discussion
Solved
Filter by column and dynamic average
Hello everyone, i was not able to find a solution online to my query.  I have multiple trucks listed per licence plate and i have the days of the months numbered 1 through 31. I want to add ...
Hi nicolasvahidzei
You need to unpivot your table from PQ ( The days must be on rows):Change the column name for Day:
After closing and applying create the measure (not Calculated column) for the average :
Average_ = AVERAGE('Table'[Value])
And drag The vech, days and average to the matrix:
Add a slicer for days :
The pbix with the example is attached
Detailed guide to unpivot :
https://www.youtube.com/watch?v=tAIqopmj9RA&t=17sIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Nicolas,
1. Happy to help 🙂
2. I work at a project-based company, I'm not a freelancer. You can check my LinkedIn:
https://www.linkedin.com/in/rita-fainshtein/
I added you, let's chat on linkedin.