Posts

Showing posts from February, 2022

Fixing “Top N and others” report when filtering by date - Unplugged #35

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

Calculate Values for the Same Fiscal Week in a Previous Fiscal Year with Power BI and DAX

https://www.mssqltips.com/sqlservertip/7133/compute-fiscal-week-calculations-with-power-bi-and-dax/  

pbi-tools: Source Control and DevOps for Power BI

https://pbi.tools/  

Excel Workbook Connection to Local Power BI Desktop

https://exceleratorbi.com.au/excel-workbook-connection-local-power-bi-desktop/?utm_source=book&utm_medium=short-code&utm_campaign=scpbi-book   I think this may be unnecessary now that you can add Analyze in Excel to external tools. See  https://www.sqlbi.com/tools/analyze-in-excel-for-power-bi-desktop/

How to Return Zero Instead of BLANK

  https://www.sqlbi.com/articles/how-to-return-0-instead-of-blank-in-dax/

Using the SELECTEDVALUE Function in DAX

https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/