Forum Discussion

Do5779's avatar
Do5779
Icon for Helper II rankHelper II
4 years ago

subquery SQL in Power BI - advanced editor

Hi, I have the following problem with SQL in Power BI advanced editor.  This ist my SQL code and I want to select every product with the highest average price.  The productnumber is the product-ID ...
Need Help
BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
4 years ago

Hi Do5779 ,

 

It's not this, is it?

 

 

Pete

  • Do5779's avatar
    Do5779
    Icon for Helper II rankHelper II
    4 years ago

    hi BA_Pete thank you, but it was a typing error of me for this post. I should be "max(..."