Analytics
Reporting, Power BI, SSRS and other analytics
-
Power BI Dynamic Measures
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Measures-Titles-Using-SWITCH/td-p/200718
https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/
http:/ … more
-
Power BI Change DayOfWeek Calculation
https://community.powerbi.com/t5/Desktop/Changing-DayOfWeek-to-show-Monday-as-1-and-Sunday-as-7/td-p/409046
-
Spotfire Date Range Expressions
https://spotfired.blogspot.com/2014/09/last-week-month-date-expressions.html
-
Transform Data in Power BI with R and Python
https://www.mssqltips.com/sqlservertip/5936/transform-data-in-power-bi-with-r-and-python/
-
Power BI Disconnected Table Trick
https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
-
Power BI Storage Mode: Import, Direct Query or Dual
https://radacad.com/dual-storage-mode-the-most-important-configuration-for-aggregations-step-2-power-bi-aggregations
-
How to use DAX to return just one string value
Let’s say for a second you have a Table called TableName and the text you want to display is in a column called TextColumn. Sound like a math problem, well it isn’t; just basic DAX filtering. So the … more
-
Power BI Direct Query Limitations and Advantages
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about
https://exceleratorbi.com.au/introduction-to-directquery/
https://radacad.com/directquery-connection-in-power-bi-how-does-it-work- … more
-
Execute SQL Server Stored Procedure With User Parameter In Power BI
https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-power-bi/
-
Run Python scripts in Power BI Desktop
https://docs.microsoft.com/en-us/power-bi/desktop-python-scripts