Key date and time intelligence function examples on common use cases What Power BI DAX has a long list of different Date and Time Intelligence related functions. However, by pareto principle a couple of them… Read More »Power BI DAX How to Calculate and Filter Based on Dates
Power Query M code to create date table to cover most fiscal date related reporting needs What Most data models need a calendar table. The more the calendar table can do itself the simple and… Read More »Power BI Financial Date Table
A powerful Power BI R graph, customized matrix bubble chart, to visualize 3 facts by 2 dimensions at the same time What Sales, % of opportunities won (hitrate), and margin % are some of the… Read More »Power BI R Matrix Bubble Chart Sales Opportunity Analysis
SQL can be used to create even hundreds of thousands of linear models with one variable, quickly. What Solving the SLOPE and INTERCEPT parameters of a linear model equation with one variable is easy with… Read More »SQL How to Forecast with Linear Regression
What It is good to look after the DAX MEASURE calculation performance and user experience. Consider when it might be smarter to use Power Query or SQL or DAX CALCULATED COLUMN and make a certain… Read More »Power BI DAX When to Use Measure VS Calculated Column VS Other Tools