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