Skip to main content
Under the kover of business intelligence
  • Home
  • Copyright
  • About

Tag: dax

How to Calculate Compound Rate in Power BI

September 29, 2022September 29, 2022 Koen Verbeeck Leave a comment

Recently I had an interesting use case where I had to a compound calculation in Power BI. You can compound an interest rate for example, where you get a certain rate on your savings. Let’s say 1% (which is at the time of writing ridiculously high, but bear with me). After 1 year, you get […]

Read More

SUMX returns incorrect results with duplicates

February 27, 2020August 2, 2021 Koen Verbeeck 2 Comments

Okay, the title of this blog post could also have been “SUMX returns unexpected results with duplicates”. The results only seem incorrect because an incorrect assumption might have been made. Let’s dive into the issue with an example. The Problem Suppose we have employees entering timesheet data. An employee can work on multiple projects in […]

Read More

CALCULATE and FILTER: A Love Story?

September 6, 2017September 10, 2020 Koen Verbeeck 6 Comments

There have already been many posts/articles/books written about the subject of how CALCULATE and FILTER works, so I’m not going to repeat all that information here. Noteworthy resources (by “the Italians” of course): Filter Arguments in CALCULATE How CALCULATE works in DAX From SQL to DAX: Filtering Data In this blog post I’d rather discuss […]

Read More

Open Source Power BI Desktop Workshop

February 13, 2017August 16, 2017 Koen Verbeeck 11 Comments

I’ve created a free, open-source workshop to teach people the capabilities and features of Power BI Desktop. I was inspired to do this by Brent Ozar, who also created a free open-source course How to Think Like the Engine. If you haven’t checked out that course, make sure you do because it’s great fun and […]

Read More

Dynamically Changing Shapes in Power BI – Alternatives

February 8, 2017September 10, 2020 Koen Verbeeck 23 Comments

NOTE: the DAX presented in this blog post is written in my locale (nl-BE). This means that semicolons are used in the functions and lists instead of commas. Also, we use the comma as the decimal seperator. 0.95 (in the US) is 0,95 in my locale. A couple of well placed search and replaces should […]

Read More

Calculate a semi-additive average in DAX

November 24, 2016September 10, 2020 Koen Verbeeck 1 Comment

A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure that can be summed across some dimensions, but not all. Typically it’s the time dimension that isn’t additive. For example, the stock level at various warehouses. You can add all the stock levels of your […]

Read More

Book Review – Power Pivot and Power BI

November 15, 2016November 14, 2016 Koen Verbeeck Leave a comment

Since Power BI is all the rage right now, I was in need of some material to spice up my knowledge of DAX (read: finally understand how CALCULATE works). I’ve been following the website powerpivotpro.com for quite some time now and they always have very insightful articles about DAX and real world scenarios. Anyway, Rob Collie […]

Read More

Dynamic Security in Power BI

April 28, 2016December 1, 2016 Koen Verbeeck 5 Comments

UPDATE: the feature has changed since its introduction. For more information, see the update at the bottom of the post. In case you haven’t noticed, Power BI added a new feature in preview mode: row level security (RLS). This blog post describes how you  can use this feature to implement dynamic security. In other words, the […]

Read More

Feed

RSS

Social

  • Twitter
  • LinkedIn

MVP

Microsoft Data Platform MVP

star schema all the things
Get your star schema merchandise

Author of the Year 2014/2020/2023

Support this blog and buy me a beer

Recent Posts

  • Execute Fabric Data Pipeline from Azure Data Factory
  • Azure Data Factory Pipeline Debugging Fails with BadRequest
  • Call a Fabric REST API from Azure Data Factory
  • Cool Stuff in Snowflake – Part 14: Asynchronous Execution of SQL Statements
  • How I passed the DP-700 Exam

Categories

  • Azure (25)
  • Azure Data Factory (25)
  • Azure Devops (4)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (56)
  • Fabric (19)
  • Power BI (41)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (112)
    • MDS (8)
    • SSAS (12)
    • SSIS (46)
    • SSRS (13)
    • TSQL (9)
  • Varia (37)
  • Twitter
  • LinkedIn
  • Home
  • Copyright
  • About
Under the kover of business intelligence All rights reserved. Theme by Colorlib Powered by WordPress