Using SUMMARIZE to get a Maximum Per Day in a Period
User Rating: 5 / 5
A quick snippet on the following scenario. I had daily data of users sessions in a system and wanted to know in a given period what the maximum number of unique users on a single day was. My data looked like this: A user could connect multiple times per day, so I needed a DISTINCTCOUNT to get unique users. However for a given period I needed to know this per day. So for the period I needed to calculate the number of unique users per day in that period - which meant I needed to create an interim table using SUMMARIZE.
Tags: dax