Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I have problem with average value in chart line. How I get right value to line? Now I have used this function:
Solved! Go to Solution.
Hi @Sisko ,
According to your description, my understanding is that you want to calculate the average of each week, in this scenario, we can use the following DAX query directly:
CALCULATE(AVERAGE('Table 1'[Value]))
You can also create a calculated table with your above query, then use the above DAX query on this table.
Best Regards,
Teige
Hi @Sisko ,
According to your description, my understanding is that you want to calculate the average of each week, in this scenario, we can use the following DAX query directly:
CALCULATE(AVERAGE('Table 1'[Value]))
You can also create a calculated table with your above query, then use the above DAX query on this table.
Best Regards,
Teige
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |