Report Portal

Bucketing Values in DAX

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

 

2007-2015 VidasSoft Systems Inc.