Practice Power BI

Theory Into Practice

  • Home

Post Category → DAX

Count customers with more than X in sales?

posted in DAX on November 8, 2020 by DAX_learner

My solution is based on function SUMMARIZECOLUMNS that creates a virtual table.

Dynamic Segmentation Table

posted in DAX on October 12, 2020 by DAX_learner

In my last post I cautioned against using DAX to create a physical table. Segmentation Tables (aka Disconnected) are an exception and worth learning!

SUMMARIZE saves the day

posted in DAX on October 5, 2020 by DAX_learner

Question 1 is easy. Question 2 is tricky. It requires a virtual summary group by table. A what?

Measure Uses Virtual Table

posted in DAX on September 30, 2020 by DAX_learner

Some questions require a virtual table inside a measure to create the required data structure.

Newer posts →
 Share This
 LinkedIn

Share on Mastodon