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…
1 comments, 697 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…
3 comments, 659 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…
5 comments, 837 reads
Posted in SQL Server BI Blog on 2 July 2013