SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: July 2013

DAX: Returning the Nth Selected Value in a Slicer

A client came to me with a challenge this week that, although simple in concept, posed an interesting challenge that I hadn’t solved before using a tabular model and DAX.  She had cost information for several hospitals in a PowerPivot model.  Using an Excel pivot table published to a SharePoint…

Read more

1 comments, 705 reads

Posted in SQL Server BI Blog on 13 July 2013

We’ve Got The Power: “Power BI”, New Microsoft BI Suite Announced

Power BI: a new suite of Business Intelligence tools Over the past few months, teams at Microsoft have made several new Business Intelligence tools available for preview; some only privately and some to the public.  The entire suite will soon be available for either public preview or release under the…

Read more

3 comments, 677 reads

Posted in SQL Server BI Blog on 9 July 2013

SQL Server Pro Article: Custom Programming to Enhance SSRS Reports

I’m very excited to see my first feature article published in SQL Server Pro Magazine titled Custom Programming to Enhance SSRS Reports; How to write a custom assembly and use it to build a dynamic report dataset.  The article was posted online in April and featured in the July printed…

Read more

5 comments, 847 reads

Posted in SQL Server BI Blog on 2 July 2013