Power BI Tips

https://www.youtube.com/watch?v=r3B2mcewXSE   https://radacad.com/know-your-data-better-by-column-profiling-in-power-bi-using-power-query Go to the View tab in Power Query and enable Column quality, column distribution, and column profile. Check bottom right to choose column profiling based on sample of all rows.

  https://radacad.com/row-filtering-in-power-bi-and-power-query-remove-blank-rows-vs-remove-empty

  https://radacad.com/scenarios-of-using-calculated-tables-in-power-bi

  https://radacad.com/scenarios-of-using-calculated-tables-in-power-bi Customer Sales = SUMMARIZE(FactInternetSales,FactInternetSales[CustomerKey], 'Total Sales', SUM(FactInternetSales[Total Sales])) Top 10 Customers = TOPN(100,'Customer Sales','Customer Sales'[Total Sales],DESC)