Create a dynamic banding attribute

The goal of this example is to create an attribute on the Customer dimension table that groups the customer into age ranges to support demographic analysis:

  1. Retrieve the current dimension table with the date column to be used for segmentation. The Date of Birth column is the source for this example.
Figure 94: Customer Dimension
  1. Add variables to the let expression to support the comparison between the current system date and the dimension date (Date of Birth).
Figure 95: Current Date Variables
  • DateTime.LocalNow() ...

Get Microsoft Power BI Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.