Bucketing Values in DAX

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Let's say I wanted to analyze query performance on my SQL database. I have a log that has all the queries, the time it took them to run and the total records that were returned. I want to look at how the size of the results impacts the performance of the queries. I pull my data into Power Pivot and create a new pivot table where I put "Rows Returned" on rows and "Average Duration" in values. I get the following long results:

Read more...

Tags: design

 

2007-2015 VidasSoft Systems Inc.