Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Hi all!
I have a Sales table that shows me for each sales order the age:
Order Nr | Age | Date | Article |
100 | 5 | 01.01.2020 | ABC |
101 | 6 | 01.01.2020 | ABC |
102 | 8 | 01.01.2020 | EDF |
103 | 4 | 01.01.2020 | HIL |
Now I would like to get a matrix visual that shows me the average age for each article.
But how?
Solved! Go to Solution.
Hi @joshua1990
if you are slicing by article ony then simply AVERAGRE ( Sales[Age] )
Hi @joshua1990
if you are slicing by article ony then simply AVERAGRE ( Sales[Age] )
User | Count |
---|---|
11 | |
9 | |
6 | |
5 | |
4 |