Using SUMMARIZE to get a Maximum Per Day in a Period

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

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.

Read more...

 

Tags: dax

 

2007-2015 VidasSoft Systems Inc.