Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I have a problem with the calculation time when determining a moving average( not via date values, but via an index). The table is loaded into Power BI.
The table has about 100,000 rows and about 80 columns.
I calculate a moving average (calculated column) using:
Further I use a MEASUR:
Does anyone have an idea how I can improve the performance?
Thanks for help
Solved! Go to Solution.
Use DAX Studio to study the query plan generated by your measures. Change your measures to reduce the number of records/iterations in the query plans.
Thank you for your advice lbendlin.
But unfortunately I don't know what you mean by that?
Can you perhaps give me a hint?
Thanks Friedbert
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |