Community, Data Relish Services, SQLServerPedia Syndication

SQL Relay – Exciting new UK event! A relay rather than a rally

In the UK, an exciting and innovative event will be held in October, called SQL Relay! The SQL Server User Groups in the UK will be holding 16 User Group events in the space of four days, commencing on Monday 3rd October. The buzz of activity culminates on Thursday 6th October, where Itzik Ben-Gan will be… Continue reading SQL Relay – Exciting new UK event! A relay rather than a rally

Business Intelligence, Community, PowerBI, SQLServerPedia Syndication

SQLPass 24hop Review: Slicers in Reporting Services

Twice a year, SQLPass put on a stellar free '24 hour hop' which is aimed at engaging with SQL Server fans all over the world. Basically, SQL experts from all over the world give an hour of their time in order to present you, the SQL Server viewing public, with some SQL goodness, advice and tips… Continue reading SQLPass 24hop Review: Slicers in Reporting Services

PowerBI, PowerPivot, SQLServerPedia Syndication

DAX PowerPivot Arbitrary Time Intelligence with Fact tables containing Future Data

One thing I love about PowerPivot is the Time Intelligence feature. Aspects of Time Intelligence appear non-intuitive at first, but with practice, it becomes clear. This is all very well if you have nice, clean Time Intelligence requirements, such as Year to Date, Month to Date, and so on. However, what happens if you have… Continue reading DAX PowerPivot Arbitrary Time Intelligence with Fact tables containing Future Data

PowerBI, PowerPivot

Sorting Months from PowerPivot models in Excel Filters and Slicers

Date Sorting by month requires additional steps for Excel Filters and Slicers, and these will be discussed here. The excellent book entitled ‘Practical PowerPivot and DAX Formulas for Excel 2010’ by Tennick suggests one method of fixing the issues around the Excel slicer sorting, which involves an IF statements on an existing Month Number column… Continue reading Sorting Months from PowerPivot models in Excel Filters and Slicers