Skip to content
  • Blog
  • About
  • Blog
  • About

Power BI DAX How to Calculate and Filter Based on Dates

  • June 10, 2019February 15, 2021

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 BI Financial Date Table

  • March 5, 2019February 13, 2021

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

Power BI R Matrix Bubble Chart Sales Opportunity Analysis

  • November 21, 2018February 15, 2021

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 How to Forecast with Linear Regression

  • September 15, 2018February 15, 2021

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

Power BI DAX When to Use Measure VS Calculated Column VS Other Tools

  • June 11, 2018February 15, 2021

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

  • « Previous
  • 1
  • 2
  • 3
  • 4
  • Next »

Recent Posts

  • Data Lake VS Delta Lake – Data Upsert and Partition Compaction Management August 21, 2021
  • Azure Synapse Serverless SQL Optimization with Examples June 6, 2021
  • Power BI Composite Models Architecture Example May 2, 2021
  • How to Serve Three Dissimilar Analytics User Profiles January 14, 2021
  • How to Forecast Long-term Electricity Demand for Hedging, Residential Sector November 20, 2020

Tag Cloud

Advanced Analytics (4) Azure (2) Business Development (2) Databrics (1) Data Factory (1) data lake (2) Data Modelling (7) Data Visualization (2) data warehouse (1) DAX (6) delta lake (1) Machine Learning (2) on-demand SQL (1) Organizational Development (1) parquet (2) Power BI (11) Power Query (1) R (1) serverless SQL (2) SQL (2) Synapse (2)