Forum Discussion
akhaliq7
Post Prodigy
Post ProdigyUsing aggregations in sql query or in power bi
If we use aggregations in our sql query side by side with non aggregated data for example the following: id sales category total_count tvs sold by category 1 1000 tvs 4 50% 2 1100 ...
akhaliq7 , You should bring a detailed table. and try to have measures.
In some case, we bring in both detailed and summarized data to improve performance. But that will be case to case basis
amitchandak
Super User
Super Userakhaliq7 , You should bring a detailed table. and try to have measures.
In some case, we bring in both detailed and summarized data to improve performance. But that will be case to case basis