-
Recent Posts
Recent Comments
Judy on Just One Slice Please wessexbob on Just One Slice Please Narsimha on Just One Slice Please Shane Rose on A CUBEMEMBERPROPERTY Equivalen… wessexbob on One Slicer To Control Them… Archives
Categories
Meta
Bob\’s BI Ramblings
Author Archives: wessexbob
UK Bank Holidays in Power Query – Easter
In my previous post I showed how to calculate all of the UK Bank Holidays for a nominated year,all holidays except the Easter holidays. In this post we will wrap it up by showing how to calculate those holidays. The … Continue reading
Posted in Excel, Functions, M Code, Power BI, Power Query, UK Bank Holidays
Tagged Excel/F
4 Comments
UK Bank Holidays in Power Query
I recently built an application that needed to be able to work out the UK Bank Holidays for any given year. This is relatively easy in Excel, the only two that are a little taxing are Easter Friday and Easter … Continue reading
Posted in Excel, M Code, Power Query, UK Bank Holidays
3 Comments
London Data Culture Day 2015
At the recent London Data Culture Day, organised by Jen Stirrup, I gave a presentation on Excel Cube Functions, querying a SQL Server database uploaded into Power Pivot to provide the cube, focusing on using MDX to enhance the capability … Continue reading
Posted in CUBE Functions, Excel, Pivots, Power BI, Power Pivot, Uncategorized
Tagged Data Culture
Leave a comment
One Slicer To Control Them All
In Excel 2007, Microsoft added structured tables. Although far from being my favourite Excel feature, they are certainly a step in the right direction, and Microsoft are using them more and more in other functions. Excel 2010 saw the addition … Continue reading
Posted in Uncategorized
Tagged Excel, Excel 2010, Excel 2013, PivotTables, Slicers, Tables
2 Comments
PASSBAC 2015 Revisited
As promised at my session on Excel’s CUBE functions at PASSBAC 2015 in Santa Clara on 22nd April, here are the files that I used at that session. It was my intention to have just two Excel workbooks, a starting … Continue reading
Posted in Uncategorized
Tagged BA, BI, CUBE, Cubes, DAX, Excel, Excel 2010, Excel 2013, MDX, PASSBAC, Power Pivot, PowerPivot, Slicer
2 Comments
Patterns in the Sand
I have just received my copy of Marco Russo and Alberto Ferrari’s book, DAX Patterns (paid for copy!). I am not sure how much value I will get out of the book, I think Marco and Alberto work in a domain that … Continue reading
Bob The (Proto) Builder
I have been building a prototype application over the past week, using Power Query to take the principal data management sheet, and create a form of normalised data that I could load into a SQL Server database which I would then … Continue reading
Just One Slice Please
We all use pivot tables, don’t we? And with the introduction of slicers, we have a much more friendly and nicer way of filtering the results than the old pivot filters. One drawback of slicers is that it is not … Continue reading
Posted in Pivots, Power Pivot
Tagged Cubes, Events, Excel, Pivot table, PowerPivot, Slicer
21 Comments
Excel is for Parameters
In my last two posts, I have shown how to build a datamodel in Excel from an Excel workbook that had two levels of headings, and then I showed how to improve the code using functions. In the second I … Continue reading
A Case For Functions
One of the things I don’t like about Power Query is that the list of instructions gets quite long, when a transformation is more than just a simple replace or add columns, and becomes less easily maintained. I am a … Continue reading