Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi- Still a newbie at Dax. I am trying to calculate the average time to promotion for each grade. I created a calculated table and calculate the duration in this table MyData
My Dax to create the table:
How do I write the average of time to promotion?
Thank you for helping!
Average Time To Promotion = AVERAGE( 'Fact Promotion'[Duration] )
Best
Darek
Hi Darek
That won't work since the duration should be based on the sum of the grade. So first, I need to group by the grades, get sum of the duration by grade, then calculate average.
[AVGTTP] = averagex( values( Fact[AdjGrade] ), calculate( SUM( Fact[Duration] ) ) )
Best
Darek
User | Count |
---|---|
40 | |
26 | |
22 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |