Bucketing Values in DAX
User Rating: / 1
PoorBest 
Written by Josh Caplan   
Friday, 06 June 2014 19:19

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...

 

 

Pyramid Analytics