Report Portal

Using SUMMARIZE to get a Maximum Per Day in a Period

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, tabular

 

2007-2015 VidasSoft Systems Inc.