I want to segment aggregated data into groups. How can I automate the task of creating these segmentation groups?
Slicer#2 depends on Slicer#1
Create a 2nd slicer based on non selected values from 1st slicer.
List items selected in both slicers
I have 2 slicers based on the same column of U.S. states.
Average of Daily Totals
How can we sum individual daily totals and then average those numbers?
Count customers with more than X in sales?
My solution is based on function SUMMARIZECOLUMNS that creates a virtual table.
Dynamic Segmentation Table
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
Question 1 is easy. Question 2 is tricky. It requires a virtual summary group by table. A what?
Measure Uses Virtual Table
Some questions require a virtual table inside a measure to create the required data structure.
Create Rows From Each Row
Each row has Start and End dates. We need to create rows for dates within each date range and split the Amount into those rows.
Rename Columns Based on Position
In Power Query I select columns based on their name, unpivot other columns and load the data into the data model. Later, if the source columns get renamed, I get an error when I refresh the query.