Forum Discussion
Filter by column and dynamic average
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 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 :
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=17s
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thank you so much Rita, you are great. Do you freelance? Please send me a whatsapp or email nicolas zein (attached) at google gmail. Cheers.
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.