Power BI Tips

https://www.daxpatterns.com/parent-child-hierarchies/  

https://www.daxpatterns.com/hierarchies/  

https://guyinacube.com/2021/05/19/a-twist-on-dynamically-filtering-visuals-by-a-slicer-in-power-bi   Create a disconnected table with values that you can slice by and use in a measure' e.g. you want to select in a slicer <= $ and use that in your measure.

https://exceleratorbi.com.au/calendar-over-run-while-comparing-last-years-data   Don't display values for dates with no data.

https://dax.tips/2021/05/17/dax-count-number-of-last-known-state/  

https://www.sqlbi.com/articles/summing-values-for-the-total/   The above has a number of links to the DAX 101 articles.

https://www.sqlbi.com/tv/consecutive-days-with-no-sales-unplugged-18/  

https://www.sqlbi.com/articles/optimizing-if-conditions-using-variables/  

  https://www.sqlbi.com/articles/summing-values-for-the-total/

 Data Source is Azure SQL Database Data Source Credentials Authentication Method: OAuth2 Privacy level: None

  https://www.havensconsulting.net/blog-and-media/toggling-report-page-tooltips-with-bookmark-buttons

https://www.sqlbi.com/articles/show-previous-6-months-of-data-from-single-slicer-selection/  

https://docs.microsoft.com/en-us/power-bi/learning-catalog/paginated-reports-online-course  

  https://hatfullofdata.blog/

  https://www.sqlbi.com/articles/import-data-from-tabular-model-in-excel-using-a-dax-query/

  https://docs.microsoft.com/en-us/learn/certifications/exams/da-100

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-tables  

  https://www.sqlbi.com/articles/using-keepfilters-in-dax/