In import mode I just make a new column with the average calculation, but now in Direct Query I cannot use average when making a expression for a new column. What is the best approach to acheive this?
@Peavey , You have to think the same in terms of measure.
In case it is simple Avg
Avg Measure = Average(Table[A])
If that was a calculation at the row level , try like
Avg Measure = AverageX(Table,Divide(Table[A],Table[B]))
@amitchandakclose but not quite.
I have 10 rows I need to average. Tried your solution and it works on fex. 2 rows. But when trying all 10, I get the error message: Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your quesry, and try to simplify them.
You can't create calculated column in PBI with Direct Query mode. But you can create measure. There are some limitations please refer the below image and link:
For more deets, please refer the below link;
We are excited to announce the Power BI Super Users!
Overview of Power BI 2020 release wave 2!
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.