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.
Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
never-displayed
View discussion in a popup
Unpivot your data, either in Power Query or in DAX. You can create tables out of columns of a row on the fly in DAX by using the { } syntax. Then you can use averagex over that table.
Table constructor - DAX | Microsoft Docs
