Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have the following data in power BI (columns 1 - 3). I'm struggling with the DAX to create a column (column 4) with the average of the Values (column 3) for Weeks 9 and 10. The value in the new column "Week9&10 Average" should be unique based on the facility name in the first column. Thanks in advance!
Solved! Go to Solution.
Column = AVERAGEX( filter('Table', 'Table'[Facility]=EARLIER('Table'[Facility]) &&('Table'[Week]="Week9"||'Table'[Week]="Week10")) ,'Table'[Value])
Column = AVERAGEX( filter('Table', 'Table'[Facility]=EARLIER('Table'[Facility]) &&('Table'[Week]="Week9"||'Table'[Week]="Week10")) ,'Table'[Value])
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |