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://www.youtube.com/watch?v=KI2eYBI0lF0&t=338s   Presentation begins around 9:00 minutes

https://www.youtube.com/watch?v=zktkhM9ZTAE  

https://www.daxpatterns.com/currency-conversion/  

  https://docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions Precedence example: Time Intelligence calculation group needs a higher precedence than Averages calculation group.

-- Get the colors selected in the slicer VAR SelectedColors = CALCULATETABLE( VALUES(Product[Color], ALLSELECTED()) -- Get All Colors VAR AllColors = ALL(Product[Color]) -- Get the colors not selected in the slicer VAR NotSelectedColors = EXCEPT(AllColors, SelectedColors)

  https://www.youtube.com/watch?v=l6si02kf4eU

https://www.youtube.com/watch?v=dZIG72afz84  

https://www.youtube.com/watch?v=qPDjCuvKWCw  

  https://www.youtube.com/watch?=NorDWXgCE3E&list=PL76KzyW9CRSr3HRfV5Qpsr0S0HyuTU09J Flips between relative date slicer and between date slicer by using a toggle.

https://www.sqlbi.com/articles/customizing-default-values-for-each-user-in-power-bi-reports/  

  https://www.mssqltips.com/sqlservertip/6917/working-days-calculator-power-bi/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20210714

  https://www.fourmoo.com/

  https://www.youtube.com/watch?v=AHiCE1N0XHE

  https://www.youtube.com/watch?v=fKygF7VEJnQ Create table 'Date Periods' that has every date for each date period. Create many to 1 relationship between 'Date Periods' and Calendar, set Cross Filter to Both. Filter the date slicer visual with this measure: Date Slicer Filter = IF(SELECTEDVALUE('Date Periods'[Type]) = "CUSTOM", 1, 0) When 0 is returned, the date slicer is disabled.

https://www.youtube.com/watch?v=5TaZQFc-t58  

https://powerbi.tips/  

  https://www.mssqltips.com/sqlservertip/5998/getting-started-with-power-bi-and-power-query-for-simple-etl--part-2/

  https://www.mssqltips.com/sqlservertip/4945/design-patterns-for-calculated-tables-in-power-bi/

  https://www.sqlbi.com/blog/marco/2021/06/29/choosing-azure-analysis-services-or-power-bi-premium-for-large-datasets/

https://www.youtube.com/watch?v=oN6mOmEruOQ  

https://prodata.ie/blogs/   Good resource for financial modelling in Power BI

  https://github.com/ProdataSQL/FinancialModelling