Practice Power BI

Theory Into Practice

  • Home

Posts Tagged → CALCULATE

Counter in a visual

posted in DAX on October 9, 2021 by DAX_learner

I heard that it’s a bad idea to add a counter inside a visual. But can I do it?

multiple date fields in fact table

posted in DAX on October 3, 2021 by DAX_learner

A fact table can have multiple date fields. I’ve seen this in demos and wanted to practice.

Running Total

posted in DAX on August 24, 2021 by DAX_learner

I’ll review some basic DAX running totals (aka cumulative totals) and then various advanced examples.

Context Transition

posted in DAX on February 15, 2021 by DAX_learner

I’ve practiced context transition a lot recently. I’ll review what I’ve learned and revisit the theory from book ‘The Definitive Guide to DAX’.

Change Total Row Calculation

posted in DAX on January 19, 2021 by DAX_learner

If totals in your viz aren’t showing what you want DAX can change them.

Top Product Sales by State

posted in DAX on January 11, 2021 by DAX_learner

Understanding the measure solution turned out to be more complex than I thought.

Funnel Chart

posted in DAX, Visuals on January 4, 2021 by DAX_learner

I’m going to build a Funnel chart and recreate tooltip values using DAX measures.

80-20 Rule

posted in DAX on December 29, 2020 by DAX_learner

Let’s use DAX to see if transaction data adheres to the 80-20 rule.

Categories

  • DAX
  • Power Query
  • Visuals

Recent Posts

  • Working With Totals
  • Counter in a visual
  • multiple date fields in fact table
  • Dynamic X axis on charts
  • Running Total
 Share This
 LinkedIn

Share on Mastodon