in

Adatis BI Blogs

Browse by Tags

  • 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 Calculations and Selections in MDX'...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 02-27-2010
  • 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 Edition, we're lucky that we have a variety...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 02-11-2010
  • PowerPivot CTP3 Released

    Following last week's release of the November CTP for SQL Server 2008 R2, the latest CTP for PowerPivot is now also released! The links for the downloads are: 32 Bit PowerPivot Download 64 Bit PowerPivot Download PowerPivot Main Download Page Included in the new CTP3 features are several new DAX...
    Posted to Jeremy Kashel's Blog (Weblog) by Jeremy Kashel on 11-18-2009
  • Creating a Custom Gemini/PowerPivot Data Feed – Method 1 – ADO.NET Data Services

    There are already a few good Gemini/PowerPivot blogs that provide an introduction into what it is and does so there is no need for repetition.  What I haven’t seen are examples of how existing investments can be harnessed for Gemini/PowerPivot based self-service analytics. This series of posts focuses...
    Posted to Sacha Tomey's blog (Weblog) by sachatomey on 10-20-2009
Page 1 of 1 (4 items)