Dutch Data Dude

Data Nerdiness

Search
  • Blog
  • Shop
  • About
  • Disclaimer
  • Blog
  • Shop
  • About
  • Disclaimer
  • Power BI Pro Tip: show 0 instead of (Blank)

    / May 12, 2020

    Default behavior of Power BI is to show (Blank) even when summing a numerical column that happens to be all empty. Want to show 0 instead? COALESCE helps.

    read more
  • Ultimate Time Based Calculations Cheat Sheet for DAX / Power BI (including Week based calculations)

    / April 6, 2018

    Power BI provides great time intelligence features to calculate Year-to-date (YTD), Month-to-date (MTD) and Quarter-to-date (QTD) totals. There is no such thing as Week-to-date (WTD) or Period-to-date (PTD) where period could be any arbitrary period definition (I…

    read more
  • Power BI Pro Tip: Pareto analysis with DAX / Power Pivot

    / June 23, 2015

    Today’s post is a guest post by Michiel Rozema (https://www.linkedin.com/in/michielrozema). Thanks Michiel! Dutch Data Dude Jeroen approached me with the question whether it would be possible to create a Pareto chart from a Power Pivot model, using…

    read more
  • Power BI Pro Tip: making date / time calculations work (Time Intelligence)

    / June 9, 2015

    Ever so often I get asked how to do a year-over-year, quarter-over-quarter, month-over-month or year-vs-year calculation in Power BI. In most cases people would like to create a KPI to measure a certain periods performance compared to…

    read more
  • Power BI Pro Tip: Confusion about TOPN() versus RANKX()

    / October 21, 2014

    This post serves as a follow-up on my Power BI Pro Tip about using RANKX to show Top X results. I am writing this because I discovered that there is a lot of confusion about the RANKX()…

    read more

Shop (more available)

  • Data Artist sticker $7.99
  • Data Artist (dark colors) $21.99
  • SQL Super(wo)man sticker $7.99
  • Power BIer (Yellow Logo) $17.95
  • Evil pie chart Ni sticker $7.99
  • Data. sticker $7.99
  • AI: Artisan Intelligence sticker $7.99
  • Data. (light colors) $21.99
  • Data. (dark colors) $21.99
  • Evil pie chart (dark colors) $21.99
2021 Dutch Data Dude | Bard Theme by WP Royal.
Back to top