DAX Nuggets

  https://exceleratorbi.com.au/removefilters-in-dax/

https://radacad.com/showing-ranking-in-a-visual-in-power-bi-using-rankx-dax-function  

  https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept/

https://www.sqlbi.com/articles/understanding-context-transition-in-dax/  

https://www.sqlbi.com/articles/introducing-calculate-in-dax/  

https://www.sqlbi.com/articles/mark-as-date-table/  

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

https://www.sqlbi.com/articles/sorting-months-in-fiscal-calendars/  

https://www.sqlbi.com/articles/previous-year-up-to-a-certain-date/  

https://www.sqlbi.com/articles/using-concatenatex-in-measures/   UNICHAR(10) is a newline

https://www.sqlbi.com/articles/automatic-time-intelligence-in-power-bi/  

  https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/ Use FORMAT([Date], "\QQ") for Quarter; e.g. QN Remember to Mark as Date Table

  https://www.sqlbi.com/articles/year-to-date-filtering-weekdays-in-dax/

https://www.sqlbi.com/articles/counting-working-days-in-dax/  

https://www.sqlbi.com/tv/optimizing-summarize-by-using-addcolumns-unplugged-40/   Don't use SUMMARIZE to calculate; just use it to group. Use ADDCOLUMNS, SUMMARIZE, then calculate.

https://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/  

https://www.sqlbi.com/tv/creating-custom-groups-using-calculation-items-unplugged-24/  

https://www.sqlbi.com/articles/using-allselected-in-composite-models/  

  https://www.youtube.com/watch?v=2HkBbqxBzF0

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

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

https://www.youtube.com/watch?v=DGPvGqzQteM   Article:  https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/

  https://www.sqlbi.com/articles/understanding-the-optimization-of-switch/