Jeremy Kashel's Blog

Browse by Tags

All Tags » PowerPivot » Analysis Services (RSS)
Power View Default Field Set
Here's another quick tip when creating data models for use with Power View - Default Field Sets can be created in both Tabular SSAS and PowerPivot that give the user a shortcut for automatically adding multiple fields to a report. As an example, here's...
Working with Images in Power View
Power View includes several ways to create visualisations with images, ranging from a simple table, to the scrollable tile visualisation. In this post I’m going to explain a bit about the tile visualisation, showing how it can be used in Power View, before...
Allocations in PowerPivot Using DAX
Although I didn't mention it, the inspiration for my last post was the excellent MDX Solutions 2nd Edition . Whilst flicking through the book a while back, I though it would be interesting to see how DAX and PowerPivot could handle the so called 'Common...
DAX Closing Balances
One of the often required calculations for users in reports is to be able to calculate a point-in-time closing balance, which is especially relevant when dealing with stock levels or financial data. In the Analysis Services world, at least in the Enterprise...