Forum Discussion
SQL VS DAX mental Set
My view is you do all *necessary* transformations in SQL, and then write measures in Power BI to do the calculations. You said your team does everything in SQL and avoids measures - that is the difference between the two. My view is you are better to shape the tables in SQL if you have pros that can do this, rather than do it in Power Query. You should generally load the lowest level of detail needed into PBI and do not preaggregate the data (something SQL pros love to do). Hope that is clearer.
i totally agree with you, DAX has its learning curve
i started working on dax since PowerPivot came up and still learning, but what I found is that it needs some mind shift in how the measures are been written and iterated
i always follow SQLBI for updates and more DAX explanation, let me see if i can book some courses online for my team donw the road, because as you said, writing DAX in a poorly way can affect the performance a lot, we used to learn it by trial and error then optimize
I offer instructor led training into all time zones around the world if you are interested. https://exceleratorbi.com.au/learn-power-bi-from-an-industry-expert/
if you want to see what people think about my teaching style, read my book reviews on Amazon.
https://www.amazon.com/product-reviews/B079G45FS9/ref=acr_dp_hist_5?ie=UTF8&filterByStar=five_star&reviewerType=all_reviews#reviews-filter-bar